5 Replies Latest reply: Feb 14, 2014 6:49 AM by Manish Kachhia RSS

    How to count the occurences of 'OTHERS'  ONLY per field in a pivot table?


      Dimension:       V1

      One of the values is 'OTHERS'

      HOW do  I count the occurrences of  'OTHERs'  ONLY in a pivot table?


      I want to do this  for other dimensions like V2, V3, etc.,


      Sample output:

      Dimension          Count(Others)       Percent

      V1                           20                         60%

      V2                           130                       30%

      V3                           12                         45%


      Thanks heaps in advance.