12 Replies Latest reply: May 10, 2016 9:24 AM by Manish Kachhia RSS

    Pivot table object

    Prasanta Kumar

      hi,

       

      i have a pivot table like below.

       

         

      GroupCountUniqueCount
      Team133
      Team218
      Team32626

       

      for measure column "Count" - i am using the formula "count(members)".

      for measure column UniqueCount - i want to get the normal count(members), but under Team2, it should not count the members that already have been counted in team 1 and Team3.

       

      Under Team2, we have few members from team 1 and Team 2, and i want to exclude them in my count.

       

      is it possible?

       

      thanks

      Prasanta