3 Replies Latest reply: Jan 26, 2017 7:25 AM by Vineeth Pujari RSS

    Pivot tables and sums

    John Schmidt

      Hi,

       

      i have a quick beginner question to pivot tables in Qlik Sense.

      Below you see a simple example with a year dimension and a order number dimension.

      I saw that you can set to show sum values in the dimension settings - this is always calculated per row though.

      However i would like to have a sum over each column in other words the row SUM is my goal.

       

      Can anybody explain to me how to do this?

       

      201720162015

      Order 1

      147
      Order 2258
      Order 3369
      SUM61524