This content has been marked as final. Show 3 replies
I need some help with a pivot table that has frequencies along with associated percentages.
So I used this expression as a dimension in the pivot table for the frequencies:
Then need to use something like this to calculate the percentages:
count( distinct if(StatusID = 2, BenKey )) / count(distinct total <........> if(StatusID=2,BenKey))
But I need to insert the dimension above in the <...> to get the correct totals per frequency but it doesn't work if you put that expression in.
What can i do??