6 Replies Latest reply: Oct 20, 2016 6:45 AM by Sunny Talwar RSS

    Total in all rows

    Inês Castelhano

      Hi all,

       

      I have this table in Qlik Sense:

      print.png

       

      And I am using the following expression for last column:

      sum(Aggr(Sum({$<Product=,Flag={'Sales'}, Source={'MySales'}>}Value),Year_Month))

       

      I get the total (I want the total of the first column - 859 709 705.56) on the total aggr column, but I want this value to be shown in all rows. Because basically I will need to divide the first column values by this last value.

      Does anybody know how to do this?

       

      Thanks in advance!

       

      Cheers,

      Inês