7 Replies Latest reply: Sep 6, 2017 4:58 AM by Michael Simonsen RSS

    Row percent for subtotals in pivot table Qlik Sense

    Michael Simonsen

      Hi!

       

      In a Qlik Sense pivot table I want to show row percentages adding to 100 % for each row/subgroup.

      Here's my pivot table:

      pivot_subtotal_row_percent.png

      The row percent for each year is correct. It sums to 100%.

      But I also need a row total of 100% for each Study Programme. That is: in row no 3 (the B-DMD Study Programme) the percent of Females should be 27 / (27+37) = 42,2 % and not the 9,9%.

       

      The percent is calculated with this expression:

       

      SUM(ADMITTED)

      /

      SUM(total <STUDYYEAR> ADMITTED)

       

      Any ideas?

       

      Best regards