Above function and pivot tables

[mhassinger]

I have chart that looks like this. Year is the dimension, the other columns are expressions.

Year     Value     vs. PY

2014     1000          -

2015     2000     100%

2016     2500     25%

I am getting the "vs. PY" value with an expression that looks like:

( Sum(Value) - Above(Sum(Value)) ) / Above(Sum(Value))

It's all great until I make it a Pivot Table and drag the fields around so that Years are the columns, and the expressions are rows. Then the "vs. PY" row has now values.

Any idea how to keep the same logic but have it work pivoted as described?

[its_anandrjs · Accepted solution]

Try with the Before in the expression in place of the Above use Before but check your cell data also.