Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2013
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table Help

    Hi, please see the attached. I have attempted to explain the solution I am looking for in the text box on the worksheet.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I think the easiest solution is to you will need to modfy the pivot to include a column of "Type G/L" which has the Label like "Original" and "Proposed".

    This would require creating a column and marking all as "original" (I did it in Col W), then in Col X you can create another new column of "All G/L" (you can change the names as desired) with a formula in X2 of:
    =IF(W2="original",J2,U2)

    This can be copied down the column.

    Then you need to copy all the rows of the table and append it to the bottom of the current data. Then in Col U, make all the newly added rows have "Proposed".

    Then create the pivot using the "Company" and "All G/L" as row labels, "Type G/L" as a column label and use the "Sum of client_total" as the Values. Outside the pivot you can then create your column of differences.

    I have attached a modified workbook with these changes.

    Steve
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •