
Re: How to get percentages to add up to 100% when dividing by the distinct count
Stefan Wühl Mar 26, 2013 10:06 AM (in response to omersami)You can try an advanced aggregation, like
=sum( aggr( count(DISTINCT ...),Dimension))

Re: How to get percentages to add up to 100% when dividing by the distinct count
omersami Mar 26, 2013 10:11 AM (in response to Stefan Wühl )Thanks. I considered using aggr but didn't follow up on it since there is more than 1 dimension. Could I use the same method for 2 or 3 dimensions?

Re: How to get percentages to add up to 100% when dividing by the distinct count
Stefan Wühl Mar 26, 2013 10:33 AM (in response to omersami)Should work, just add all your table dimensions to the aggr() function's dimension list:
=sum( aggr( count(DISTINCT ...),Dimension1, Dimension2, Dimension3))

Re: How to get percentages to add up to 100% when dividing by the distinct count
omersami Mar 26, 2013 11:02 AM (in response to Stefan Wühl )Thanks. When I do a total sum it does kind of work.
The sum of all individual rows do add up to 100%. But now the total percentage is less than 100% and the sum of the subtotal are also less than 100%. The individuals rows do not add up to the subtotals and the subtotals do not add up to the total or to 100%.

Re: How to get percentages to add up to 100% when dividing by the distinct count
Stefan Wühl Mar 26, 2013 4:36 PM (in response to omersami)Try
sum(
aggr(
count(distinct Person) / sum(total aggr( count(distinct Person),Dimension1,Dimension2,Dimension3))
,Dimension1,Dimension2,Dimension3)
)

Re: How to get percentages to add up to 100% when dividing by the distinct count
omersami Mar 28, 2013 7:20 AM (in response to Stefan Wühl )That doesn't help either. And it's not possible to fit it along with other functionalities I have in the pivot table.
So I decided to change what I am counting to avoid this problem. Thanks for your help!

Re: How to get percentages to add up to 100% when dividing by the distinct count
Vidya Ramanujam Aug 1, 2013 4:34 PM (in response to omersami)Hi,
Im facing the same problem. I am trying to create a bar graph with the percentage of total number of people who have A's. so i am using the formula:
Count
({$<NewScore={'A'}>} DISTINCT UserName)/Count(DISTINCT UserName)
But the answer is showing more than 100%. Can u please help.





