4 Replies Latest reply: Jun 26, 2018 2:49 PM by sahiba kaur kohli RSS

    Calculate Subtotal and Grand total

    sahiba kaur kohli

      hi Team,

       

      I have a list of States in counties X and Y and their respective sales:

       

      Country     State          Sales 2018

         X                 A                    100

         X                 B                    200

         X                 C                    250

         X                 D                    50

         Y                 E                    400

         Y                 F                    150

       

      Now, in qlik sense if I select any State: for example A. Then the output table should show the sum of States as well as the sum of nation. The output should be:

       

      State             Sales 2018

      A                     100

      All States         600

      All Country      1150

       

      Please help..