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.
Before(sum(Value)) will bring you the value of left column
1-Before(sum(Value))/sum(Value) returns the variation
Probably too many hard-corded value and can somehow be automated
The result is ok.
Retrieving data ...