I'm just now exploring power pivot, and so far it's a great tool. But I came across an annoying problem. Is there a way to drill up from within a pivot chart by a button or slicer or some such?
I have a hierarchy set up, and it works great to drill down. I just click on the chart element I want to see in more detail, both table and chart drill town to the next level and all the data is displayed nicely. I would like to just hit a button to go back to the previous level though, and it doesn't seem to be provided. Am I missing something? Right clicking and navigating to drill up each time is kind of a pain.
Bookmarks