Rangesum problem in pivot Table

[#1]

Hi,

first of all any thnaks for your atttention.

please can you help me to understand why expression "cumulative" and "above" in the pivot that i attach doesn't works?

when dimension Period Change the rangesum and above function restart to 0....

many thanks and best regards

[swuehl · Accepted solution]

That's because the Period Change indicate a new column segment. I think you want the TOTAL qualifier here:

=rangesum(count(ID_Weld2),Above(TOTAL count(ID_Weld2),1,rowno(TOTAL)))

[MK_QSL]

RangeSum(Above(TOTAL count(ID_Weld2),0,RowNo(TOTAL)))

[#4]

you are right!

many thanks for your help!