How to calculate Growth percentage in pivot table ?
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