Set Analysis - Pivot table

[sotirchou]

Hello all,

I have a pivot table with

Dimensions: Group 2 Name and Code.

Columns: Year and Month.

I want to sum the current Column with the next 2 months columns.

For example: 135,8 + 131,1 + 94,5 for any group 2  name. I have tried rangesum, but didn't work.

Thanks in advance.

[JHuis]

Dear,

you could use the before function.

https://help.qlik.com/nl-NL/sense/May2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecor...