I have a PowerPivot data model with two hierarchies created. I want to create a PivotTable where each hierarchy is its own column (in the row fields) but where the drill down functionality for each operates as compact view. I want to be able to drill down on each hierarchy independently from the other. The Table format of the PivotTable can accomplish this, but then with each drill down, it creates a new column, which I don't want.
Is there any way to do this?
Is there any way to do this?