Pivot table with running sum (2)

[lucarizziero]

Hi

I have the following Pivot Table                                             

product	colour	date	cust. Order	running sum
141MBACAL0094	CR31	01/02/14	45	45
141MBACAL0094	CR31	02/02/14	19	64
141MBACAL0094	CR31	01/03/14	3	67
141MBACAL0094	OL71	01/02/14	52	52
141MBACAL0094	OL71	02/02/14	26	78

I'm not able to obtain the column named [running sum]: it should contains the running sum of the cust. Order column restarting each change of the combination [product]+[colour] dimensions.

In the solutions posted I can obtain a continuous running sum, while I need it restart each time the dimensions [product]+[colour] changes.

Thanks

[tresesco]

Try like:

rangesum (above(total [cust. Order],1,2)))

Note: It's working would depend on your dimension occurance. If you find this not working, please share a sample app.

[nizamsha]

RangeSum(Above(TOTAL SUM(S),0,1000))

[nizamsha]

RangeSum(Above(TOTAL SUM([cust. Order]),0,1000))

[lucarizziero]

here is a sample app

thanks

Luca

[qlikpahadi07]

try this:

Aggr(RangeSum(Above(SUM(cust_order),0,RowNo())),colour, k)

check the attachment

[tresesco]

In that case you can use the expression without TOTAL like:

RANGESUM(Column(1),ABOVE( Column(2)))

But then your result will change, the running sum would start over again for each new member of second last dimension value (here date). Unfortunately, TOTAL can't be used to control the dimension level. I.e, if you use it it will disregard all dimensions but not till a specific level.