I am trying to create a Pivot table that has the following categories:
Column Headers - Task Code, Approved Expenditures, Invoices in Progress, Remaining Work Order Balances, Total Field (Summing across the previous three columns), PA Period - which will show approved expenditures per month (e.g. Sep-14, Oct-14, etc.). If I cannot include the Total column, that is ok. It is just preferred to include it.
The data source is located on a different spreadsheet. The columns associated with each of the above categories are outlined below.
Task Code - Column K
Approved Expenditures - Column AB
Invoices in Progress - Column AC
PA Period - Column AA
I have attached an example file illustrating the data source and what the desired pivot table would look like.
I can get the first four columns, but when I include the PA Period, the table gets messed up. Can anyone help out? I even tried to slice two tables together. One with the first four columns and the other with the PA Period. But since the tables aren't exactly the same, it does not work.
Thanks!
Mike
Bookmarks