Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to calculate Growth percentage in pivot table ?

Hi

I want to calculate Growth% for Boys, girls,Mens,Unisex in the following Pivot chart.How to calculate the growth% between 17P and 18P? formula used to calculate growth% should be (current season)-(previous_season)/(previous_season) ie i want (872)-(788)/(788).

Growth rate for boys should be calculated after total of  18P. Paint1.png

Note-Here 18P and 17P depict seasons.18P depict current Season and 17P depict previous season.I am using following expression

=num(sum(quantity_sold),'#,##0.0')

0 Replies