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:



      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!