0 Replies Latest reply: Apr 11, 2013 8:01 AM by Simon Goodman RSS

    Collapse rows/columns in a pivot table

    Simon Goodman

      I have pivot table with a vertical product dimension and horizontal period dimension. Is there a way to collapse/hide/remove rows and columns using a conditional expression? The expression is used to look for exceptions, values greater than x% and values less than y%.

       

      I have looked the forums but not found my answer. As a starting point I looked at IF and attached is an example.