How to calculate change percentage in pivot table and show on chart

Question

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?

Katerina Kovriga {Stiltsoft} · Answer

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.

emagnun · Answer

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???

Katerina Kovriga {Stiltsoft} · Answer

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.