Results 1 to 2 of 2
Thread: Pivot Table Help
2014-01-07, 17:32 #1
- Join Date
- Jan 2013
- 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.
2014-01-07, 18:06 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- 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:
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.