Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table

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

4 Replies
Not applicable
Author

Can you please be more clear.

Not applicable
Author

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

Not applicable
Author

aammRataTotal201001201002201003201004201005201006201007201008201009201010201011201012201101
-654.279-1.964.401-1.246.5812.086.5195.190.6135.701.1104.550.5785.746.7527.750.80710.251.03512.474.40912.574.43112.587.894
12.587.894-654.279-1.310.122717.8193.333.1003.104.095510.497-1.150.5321.196.1732.004.0552.500.2282.223.374100.02213.463

i want if is possible to obtain the yellow row who is cumulative values of the total row

Thanks a lot

Not applicable
Author

You can make use of "Cumulative" function under Expression Tab to achieve the above result.

Regards

Rajesh