Hello everybody,
I have a problem on Qlik Sense. In a Pivot Table I want to do a cumulative sum for only one dimension and a normal sum for the others.
In the measure expression I used the following function:
=if(dimensionality()=3
,rangesum(above(Total sum([Valore Co. Ge.]),0,RowNo(Total)))
,sum([Valore Co. Ge.]))
It seems to be good for a cumulative sum for dimension 3 and a normal sum for other dimensions untill when I expand my pivot table and I have a zero line values like the screen:
How could I fix my formula to have the correct cumulative sum when I expand my Pivot Table instead of the zero values?
Thanks in advance
Patrick