0 Replies Latest reply on Mar 12, 2013 7:54 AM by damian thomas

    Subtotal Variance

    damian thomas

      Hi,

       

      I created a pivot chart that contains Job and Revenue amount. The type of Revenue is determined by the type column.

      There are two types  'A' or 'B'. This determines Actuals or Budget.

      There is a Job column as well. Containing 105 and 106. I attached a sample workbook.

       

      My output

       

      Job               Dept Name              Revenue                      

      105               105 Budget              1912

                           105 Actual                519

                           Total                         2431

       

      106                106 Budget              1100

                            106 Actual                 350

                             Total                       1450

       

       

      Desired Output

       

      Job               Dept Name              Revenue                      

      105               105 Budget              1912

                           105 Actual                519

                           Total                         1393

       

      106                106 Budget              1100

                            106 Actual                 350

                             Total                         750