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.
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')