Was hoping for some pivot table expert to provide some guidance here. Thanks in advance.
I have 2 12-month project management financial forecasts that I need to compare and report on the differences. Here is some sample data:
There is only one difference between the 2 forecasts, a $500 reduction in Dev Consulting for April.
I have been able to create the Pivot Table to show the forecast by Spend Type for each forecast, but now I need to have a third section that shows the differences.
Here is a google drive link to a sample file:
Thanks!
I have 2 12-month project management financial forecasts that I need to compare and report on the differences. Here is some sample data:
Forecast Date | Spend Type | Description | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
1/1/2020 | PO | Dev Consulting | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 12,000 |
1/1/2020 | PO | Test Consulting | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 6,000 |
1/1/2020 | HW | Servers | $ 2,000 | $ 2,000 | $ 4,000 | ||||||||||
1/1/2020 | Employees | 3 HC | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 9,600 |
2/1/2020 | PO | Dev Consulting | $ 1,000 | $ 1,000 | $ 1,000 | $ 500 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 11,500 |
2/1/2020 | PO | Test Consulting | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 500 | $ 6,000 |
2/1/2020 | HW | Servers | $ 2,000 | $ 2,000 | $ 4,000 | ||||||||||
2/1/2020 | Employees | 3 HC | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 800 | $ 9,600 |
There is only one difference between the 2 forecasts, a $500 reduction in Dev Consulting for April.
I have been able to create the Pivot Table to show the forecast by Spend Type for each forecast, but now I need to have a third section that shows the differences.
Here is a google drive link to a sample file:
Forecast.xlsx
drive.google.com
Thanks!