1 Reply Latest reply: May 23, 2012 12:03 PM by Jason Michaelides RSS

    Detail Drilling from a numeric cell  in a pivot table to a detail tab.

      A requirement for my application is to able to click on an expression cell in pivot table, and then launch a filter and automatically move to a detail tab.  My users currently employ this feature in excel.

       

      The only method that I think to utilize to accomplish this task is to set up a corresponding set of values within a dimension for the approximated thirty expressions within the pivot table, so that each expression has a related classification or category dimension.   Then I can filter on this dimension and automatically move to a detail tab based upon the filter button or text box actions.

       

      Has anyone else encountered this design issue and if so what was your strategy to resolve this problem?