Cumulative Sum order by dimension

[louisernould]

Hi the Qlik Community !

I have a small problem and I think it's about synthax. I have a table, and I want the cumulative sum of a dimension.

On the table above, I have [Nom], and [Taille], and I want the cumulative sum of the [Taille] but order by the dimension [Nom].

I already try 2 differents things, but It's not what I want...

Nom	Taille	test	RangeSum(Above(Sum(Taille),0, RowNo(total)),Nom)	If(Dimensionality()=1 ,   Aggr(RangeSum(Above(Sum([Taille]),0,RowNo(TOTAL))),Nom) ,     IF(Dimensionality()=0 ,        Sum(Taille) ,RangeSum(Above(Total Sum([Taille]),0,RowNo(TOTAL)))))	WHAT I WANT
A	6	non	6	6	6
A	10	oui	10	16	16
A	11	non	11	27	27
B	3	non	3	30	3
B	4	oui	4	34	4

If someone has the solution, he will be my hero !

Thanks

Louis

[Gysbert_Wassenaar]

See attached qvw.

[louisernould]

Thank Gysbert,

actually, it's not working a 100%. With your solution, I want to keep the 'test' Dimension, and when i keep it, my culumative sum bugs and doesn't work...

[Gysbert_Wassenaar · Accepted solution]

Change the expression to if(above(total Nom)<>Nom,Taille,rangesum(above(total MySum),Taille))

[louisernould]

Thanks so much !!! It's working !! OK, you're my hero now