Pivot table: Percentage difference between columns on the same dimension

[marcobombo]

Hi,

I have this problem. I want to make the percentage difference between the columns in a pivot table on the same dimension (Year).

It is possible?

I attache the example.

Thanks

[Clever_Anjos]

Before(sum(Value)) will bring you the value of left column

[Clever_Anjos · Accepted solution]

1-Before(sum(Value))/sum(Value) returns the variation

[sunny_talwar]

This?

Probably too many hard-corded value and can somehow be automated

[marcobombo]

The result is ok.