Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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 ?
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
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
Thanks Swuehl.
It is exactly what I need.
Swuehl,
I can I have a total (%) rather than '-' ?
Possibly, yes.
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