Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try with the Before in the expression in place of the Above use Before but check your cell data also.
Try with the Before in the expression in place of the Above use Before but check your cell data also.