Looking to set up hierarchies in the below format on the X-axis and Y-axis in a pivot table, can you give me any idea how to proceed?
Have bought my hierarchies into the table but not sure how to set them up on Business line with drilldown for both the hierarchies.
Appreciate any ideas you can ptich in.
Thanks
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 8 |
---|
Business | ABC |
| FGH |
| MNO |
|
| BC |
| GH |
| NO |
|
| C |
| H |
| O |
|
| sales | predictions | sales | predictions | sales | predictions |
Accounts |
|
|
|
|
|
|
wxyz |
|
|
|
|
|
|
xyz |
|
|
|
|
|
|
yz |
|
|
|
|
|
|
z |
|
|
|
|
|
|
ghjk |
|
|
|
|
|
|
hjk |
|
|
|
|
|
|
jk |
|
|
|
|
|
|
k |
|
|
|
|
|
|