Hi -
I am trying to find out the $Variance or $Delta between Categories as well as Department for my Budget data set. I have transposed this data from its original format. The data is for months Jan-April 2016. I am trying to find out the following:
Over all across Company ABC:
SUM(Gross Cost before Income) Jan - SUM(Gross Cost before Income) Feb
SUM(Gross Cost before Income) Jan - SUM(Gross Cost before Income) March
SUM(Payroll) Jan - SUM(Payroll) Feb
and then a filtered view across Departments. I'm attaching a view that I created when the data did not have the Month field.
Appreciate all the feedback & comments. Thanks in advance!
Nikhil
I think I may have solved this. Maybe there is an better / optimized way of doing this. I referenced this link for my problem Difference From Calculation
I used Table Calculations to finds the Variance between Months (Feb/Mar/April) to Jan. I created a Parameter for all my Measures and then created a Calculated Field to then find Variance across all measures between months. Not sure if I should have used LOD here.