Hi. My recollection is that in mgt studio's cube browser I can drag the highest level executives off an employee hierarchy pivot by dragging level numbers. After all, we know who the ceo is and the ceo's direct report as well.
I dont see this capability in excel 2007. When I unclick these top level execs in the filter already being used to hide ex employees, excel still shows the two highest level execs. Is there an elegant way to suppress them in excel?
I dont want to remove them from the cube, just to suppress them in one particular excel pivot.
View Complete Post