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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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