Forum Discussion
This seems rudimentary but...
I'm attempting to analyze information in a pivot table. I have three columns of information: the category account and the two sub categories for each account - this is information from financial sof...
Projects | Category | Sub costs/category | current cost | current income | |
|---|---|---|---|---|---|
Project 1 | |||||
Travel | |||||
Fuel | |||||
Lodging | |||||
| Misc |
Within the pivot table they populate as:
Project | Total Cost | |||
|---|---|---|---|---|
Project 1 | Total Cost of project | |||
Project 2 | Total Cost of project | |||
Project 3 | " " | |||
Travel | Total cost of all travel | |||
Fuel | " " | |||
Lodging | Total cost/not per project | |||
Misc1 | " " |
Can I nest these within the pivot table to analyze each project cost breakdown without filtering by project, as the list is too large?