3 Replies Latest reply: Mar 26, 2013 10:30 AM by Albert Rubio Ripoll RSS

    Final user Filtering Results by Expression on Pivot Table

      Hello,

       

      I've a pivot table with 5 dimensions and one expression ( # of Hours). The Client is asking me to filter the result of the pivot table whatever he wants by the number of Hours.

       

      E.g.

      They want clicking the column header and writing " >3" in order to show only the records who have more than 3 hours.

       

      The problem is that the expression column cannot be checked as Searchable on a Pivot Table.

       

      I know, that i can switch from a Pivot Table to a Simple Table, and this would be resolved, but it would result losing the parcial totals by one of my dimensions.

       

      Any idea how it can be solved?

       

      Thanks a lot.

       

      Albert.