Discussion board where members can get started with QlikView.
I need to calculate amount in pivot table.
Févr. Mars Calculation
5.13 6.23 (6.23 - 5.13) / 5.13 = 21%
How can I achive that ?
Go to Solution.
You can use chart inter record functions like before() or above() (use before() in your case of pivoted dimensions):
="Prix Moyen TTC" / before("Prix Moyen TTC") -1
View solution in original post
It is exactly what I need.
I can I have a total (%) rather than '-' ?
But, your total variance should indicate what based on your data? (How would you like it to be calculated?)
Total (%Prix Moyen) = Sum of Total(%) for Janv. + Sum of Total(%) for Févr. + Sum of Total(%) for Mars + Sum of Total(%) for Avr. + Sum of Total(%) for Mai + Sum of Total(%) for Juin