3 Replies Latest reply: Oct 16, 2017 12:41 PM by Devarasu R RSS

    Totals at different levels

    Rajarshi Guin

      Hi All,

       

      In my dashboard I have data in the format in a table.

       

           

      FirmAgent IDCases ClosedCases CreatedIn-Progress Cases
      A11000
      A220100
      B30100
      B420200

       

      The columns Firm and Agent ID are dimensions while others are measures.

      Now I need to show the totals based on both the firm level as well as the total for the whole table. So, the output should appear as below.

       

          

      FirmAgent IDCases ClosedCases CreatedIn-Progress Cases
      A11000
      A220100
      Totals30100
      B30100
      B420200
      Totals20300
      Totals 50400

       

      So, the first Totals in row no. 3 will show the total for firm A, i.e., sum of values for Agent Id 1 and 2. The Totals in row no. 6 will show the total for firm B, i.e., sum of values for Agent Id 3 and 4. And the Totals in row no. 7 will show the sum of values for firm A and B.


      Can anyone please tell me how to implement this in qlik sense.


      Thanks,

      Rajarshi Guin