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?

      Ex.

      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.