3 Replies Latest reply: Dec 18, 2012 12:23 PM by Fernando Suzuki RSS

    Selecting an expression in a pivot table

    V Butler

      Hi,

       

      I have a pivot table with 5 dimensions and 16 expressions - therefore, the 5 dimension columns are "frozen" while the 16 expressions are scrollable within the pivot table. The problem is, when I select one of the cells in an expression column (in an attempt to filter the dataset on a single cell value), the values for all of the other 15 expressions in the same row are also selected as filters. I only want the single cell that I select to be a filter on the dataset. How can I achieve this?

       

      Many thanks,

       

      VB