Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 1 measures Sum(total) and 1 Dimension (Year).
I line chart i have to display X-Axis my year like 2011,2012,2013,2014....
Y axis should be sum(total) but i have to display only difference % e.g (2012 sum minus 2011 sum divided by 2011 sum).
Is there any default function available like rollup sum,difference %,difference % only selected.
Thanks
Govind R
May be like this:
(Sum(total) - Above(Sum(total)))/Above(Sum(total))