Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is it possible to have in a pivot table one row with a progressive values?
e.g.
jan feb mar apr
10 -5 20 10
prg 10 5 25 35
thanks a lot
gabriele
Can you please be more clear.
Yes i beg your pardon
in a pivot table i have the total with
e.g four month
jan feb mar apr
10 -5 10 20
i want a row with the progressive values in the various month
10 -5 15 35
thanks a lot
aammRata | Total | 201001 | 201002 | 201003 | 201004 | 201005 | 201006 | 201007 | 201008 | 201009 | 201010 | 201011 | 201012 | 201101 |
-654.279 | -1.964.401 | -1.246.581 | 2.086.519 | 5.190.613 | 5.701.110 | 4.550.578 | 5.746.752 | 7.750.807 | 10.251.035 | 12.474.409 | 12.574.431 | 12.587.894 | ||
12.587.894 | -654.279 | -1.310.122 | 717.819 | 3.333.100 | 3.104.095 | 510.497 | -1.150.532 | 1.196.173 | 2.004.055 | 2.500.228 | 2.223.374 | 100.022 | 13.463 |
i want if is possible to obtain the yellow row who is cumulative values of the total row
Thanks a lot
You can make use of "Cumulative" function under Expression Tab to achieve the above result.
Regards
Rajesh