4 Replies Latest reply: Sep 14, 2016 4:05 PM by Monica Chhabra RSS

    Set Analysis in Pivot table

    Monica Chhabra

      Hi All,

       

      I am trying to create set Analysis in my pivot table as one of the measure.  I have following fields in the data table:  Seller Type, Seller Name, FTACount.  Seller Type has values Bank NSE, MMSE, MSE.  I want to calculate:  Total Tickets for all seller with Seller name based on following criteria:

      If [Seller Type]= 'Bank NSE' and Count(FTACount) >= 40 then result = 3 ticket

      If [Seller Type]= 'MSE' and Count(FTACount) >=8  then result = 3 ticket

      If [Seller Type]= 'MMSE' and Count(FTACount) >= 4 then result = 3 ticket

       

      Below is the Set Analysis I have attempted so far and is very far from what I am trying to achieve:

      IF([Seller Type] = 'Bank NSE', Count({$<[FTACount] > {39}>}FTACount))

       

      Can anyone please hep?

       

      Thanks,

      Monica