Hello,
I am new to pivot tables and I am trying to create a pivot table with multiple rows/sub rows of text that can be expanded/collapsed but the sub rows aren't populating the way I need them to.
In the attached spreadsheet, the first tab has the source data and the second tab is the results I am looking for. The third tab is the actual pivot of the source data.
When I try to create a pivot table with the source data, it creates a blank row with another blank row underneath and then it lists the sub categories. I know it creates the blank rows because there are empty cells but I am not sure to pivot the source data without selecting the empty cells.
If possible, in the pivot table I would like to be able to expand Identity and see asset mgmt. Then asset mgmt be able to expand and show the sub categories.
Any help is greatly appreciated. Thanks!
Bookmarks