|
Project title: |
Excel Pivot Table Format
|
Posted by: |
External project from PeoplePerHour
|
Started: |
05-Jul-2022 12:32 GMT |
Description: |
See attached data.
I have the main table of data in "Main".
I have setup a basic pivot table on the sheet called "Pivot". I want to show the data with categories and sub categories in expanding rows.
The problem is that the pivot table is showing 'blank' everywhere which makes the table look bad.
I want to exclude these blanks from the pivot. However i have done this already in the pivot but that doesn't work, it makes all the data disappear.
Can you fix this problem for me?
Thanks |
Project ID:
|
3269600 |
Project category: |
|
Project budget: |
|
|