1 Reply Latest reply on May 19, 2016 9:28 AM by Nikhil Sundar Rajan

    Trying to find Variance between months in Budget Data

    Nikhil Sundar Rajan

      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