Pivot table with Running sum as subtotal

[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.

Thanks

[v_iyyappan]

Hi,

Use like this running sum

=If(Alt(Above(Sum(cust. Order)),0) = 0, Sum(cust. Order),  (Sum(cust. Order) + Above(Sum(cust. Order)))

Regards,

[#3]

Please see attached

[#4]

Hi

I am also trying to do something similar to this. I would appreciate the help. I already tried what you suggested and it didn't work.

Thanks in advance,

Alba

[#5]

Thanks a lot for the example. I got it working!!

[lucarizziero]

Your suggestioni is ok for my requirements: thanks a lot

Luca Rizziero

Da: V.Iyyappan Venkidusamy

Inviato: martedì 24 settembre 2013 18.25

A: Luca Rizziero

Oggetto: Re: - Pivot table with Running sum as subtotal

<http://community.qlik.com/> QlikCommunity

Pivot table with Running sum as subtotal

risposta da V.Iyyappan Venkidusamy <http://community.qlik.com/people/V.IYYAPPAN?et=watches.email.thread> su App Development - Visualizza la discussione completa <http://community.qlik.com/message/396486?et=watches.email.thread#396486>