Calculation in Pivot Table.

[suzel404]

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 ?

[swuehl · Accepted 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

[suzel404]

Thanks Swuehl.

It is exactly what I need.

[suzel404]

Swuehl,

I can I have a total (%) rather than '-' ?

[swuehl]

Possibly, yes.

But, your total variance should indicate what based on your data? (How would you like it to be calculated?)

[suzel404]

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