Running sum of columns in Qlik Sense

[punitpopli]

Hi Experts,

I am working on a Pivot table and have a requirement in which have to sum the available column values under a new column as Total. The column are based on month selection

For e.g. I have selected month = 3,4 which has values 30,40 respectively then the total(new) column should be showing the total of two enabled columns i.e. 70. Rest of the columns will be hidden and will be displayed once a specific month is selected

I am unable to achieve this scenario in Qlik Sense, can anyone help on this?

Thanks in advance 

- Punit 

[punitpopli]

adding some of the community experts to know their thought on this 

@sunny_talwar , @tresesco , @Gysbert_Wassenaar , @swuehl , @jagan 

[tresesco]

If you put month as a dimension in pivot and then drag it to column, the expected behaviour would be as a default one - I guess.  

[punitpopli]

Hi @tresesco ,

thank you for your reply.

The requirement is to display separate column in the pivot table which will be enabled for selected month.

Hence, cannot go by this approach.

Regards,

Punit 

[sunny_talwar]

I think this can be done using an expression where you ignore selection in your inner part of the expression... for example

RangeSum(Above(Sum({<MonthField>} Measure), 0, RowNo())) * Sum(1)

But for the total itself, summing the accumulated values doesn't sound right. Do you really want to sum 30+40 or would you rather show 40 as the total because month 4 has 40?