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

# 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.

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

Count ({<Dimension = {'V2','V3'}>}Others)

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

That's helpful. Gave me an idea. I used the below formula instead.

Count({<\$(=minstring(\$Field)) = {'OTHERS'}>}\$(=minstring(\$Field)))

BUT, How do I get the percent?

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

What is the % in your case... i.e. what is the formula you have used?

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

That's a follow up question.

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

I mean what is the logic behind getting percentage...

i.e

SUM(Sales)/SUM(Total Sales)

or

COUNT([Invoice Number])/ COUNT(TOTAL [Invoice Number])

In your case may be...

Count ({<Dimension = {'V2','V3'}>}Others)/Count (TOTAL {<Dimension = {'V2','V3'}>}Others)

or

Count ({<Dimension = {'V2','V3'}>}Others)/Count (TOTAL Others)