# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. \$300 savings extended to February 9th Learn More
Contributor

## Calculation in Pivot Table.

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 ?

1 Solution

Accepted Solutions MVP

## Re: Calculation in Pivot Table.

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

5 Replies MVP

## Re: Calculation in Pivot Table.

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

Contributor

## Re: Calculation in Pivot Table.

Thanks Swuehl.

It is exactly what I need.

Contributor

## Re: Calculation in Pivot Table.

Swuehl,

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

Highlighted MVP

## Re: Calculation in Pivot Table.

Possibly, yes.

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

Contributor

## Re: Calculation in Pivot Table.

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