1 Reply Latest reply: Jul 25, 2017 10:05 AM by Sunny Talwar RSS

    Pivot tables totals percentage (QlikSense)

    Amuktha Chakilam



      I need help in generating each row total as a percentage of column total and if there are sub categories then how to generate row total as % of parent total.


      Please see the attached images to get the structure of the pivot table.


      The rows contain school brand in first image ( in the second image rows contain school brand and all the sub categories of schools); the column is Date and the measure (Total Matches)  is calculated by a expression.


      Thank you.