3 Replies Latest reply: Oct 6, 2015 8:31 AM by nagarjuna k RSS

    Frequencies and Percentages

      Hi all,

      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:

      aggr(count(DiseaseID), BenKey)

      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??

       

      Thanks

      James