3 Replies Latest reply: Jan 28, 2013 9:57 AM by Sunil Chauhan RSS

    Excluding a selection from a Pivot table

      I have a pivot with a list of clients and stats beside them.

       

      I want to permanently exclude a group of people (Tier A) from the pivot without having to make selections in the Tier list box.

       

      What is the best way to go about this?

       

       

      Client               Tier               $

       

      Client A               Tier A          xx

      Client B               Tier A          xx

      Client C               Tier B           xx

      Client D               Tier B          xx

      Client E               Tier C          xx