Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Count ({<Dimension = {'V2','V3'}>}Others)
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?
What is the % in your case... i.e. what is the formula you have used?
That's a follow up question.
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)