cumulative subtracting

[kumarkp412]

Hi  friends,

I am having small problem to calculate the cumulative subraction.

I´m Looking for a formula that can calculate the total value subtract the current value

i.e this is table i am having

year	sales
2009	100
2010	200
2011	300
2012	400
2013	500

i want to calculate the cumulative subtract as total value - current value

year	sales	cumulative-sub
2009	100	1400
2010	200	1300
2011	300	1200
2012	400	1100
2013	500	1000

So in the above table cumative sub will come base on total sales of the years - current sales

i.e total sales =1500 ,current year sales- if it is 2009 then the sales is 100 , then value is  1500-100 = 1400

.

.

.

i am not able to get the formula for that .

can any suggestion please

Thanks

Kumar

[mightyqlikers]

Hi Praveen,

use the folloing expression.

=Sum(TOTAL Sales)-Sum(Sales)

Regards

Samwise

[mightyqlikers]

Please find the attached qvw

Regards

Samwise

[kumarkp412]

Hey Sam,

Thanks for reply,

When it  was a straight table it is coming correctly , but it is a pivot table.then it is not coming correctly.

can you give me suggestions in to create  it in pivot table

Thanks

Kumar

[mightyqlikers]

it is working fine even in pivot table.

please attaché your sample qvw.

Regards

Samwise

[Anonymous]

Hola,

PFA

HTH

[kumarkp412]

ok sure

I will attachement  my sample

[kumarkp412]

This is sample qv.

In that i have given how i want to represent the values in the  table.

Thanks

Kumar