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

    Pivot tables totals percentage (QlikSense)

    Amuktha Chakilam

      Hi,

       

      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.

       

      kaushik.solanki