Hello,
I have a table that has products sold on yearly basis.
Below is my chart and pivot table generated from the table. As you can see product-A increased from 1 to 2 (100% increase) between FY2019 and FY2020. How do I get to show this change % in the chart ??? Similarly, Product-B has 50% decrease (2 to 1) between FY2019 and 2020. How to do I display that information in my chart and pivot table?
Hi @emagnun ,
You may try the following: create a sequence "your table <- Pivot Table <- Table Transformer <- Chart from Table".
And set your macros as it is shown on the screenshots:
Pivot Table macro
Table Transformer macro
SELECT T1.'Product Type', T1.'Count FY2019', T1.'Count FY2020',
ROUND((T1.'Count FY2020'*100/T1.'Count FY2019' - 100), 2) AS 'Growth, %'
FROM T*
Chart from Table macro
It seems that the result is pretty close to your case, hope it helps.
Thank you.
However, this exactly doesn't suit my needs. I would like see this from FY perspective in the X axis.
Is it possible to view the growth as something like this???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm afraid that such custom graph where you show both absolute numbers and percent of growth in comparison with the previous period is not possible within our macro.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.