6 Replies Latest reply: Feb 25, 2016 2:44 PM by Andy Faulkner RSS

    keep all filters when selecting cells in a pivot

    Andy Faulkner

      Hello

      I have a pivot table.

      When I select a cell, say intersection: value1 || A, everything works fine. However if I then select value3 || A, the A filter disappears.

      Every cell the user selects should pass both filters, not remove one if it happens to be from the row.

      How to do I achieve this behaviour?

      Thank you,

      Andy.

      col1headergroup1valueheadergroup2value

      A

      value1value3
      Bvalue2value4