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

How To sum continues accumulating amount in column

I would like it to be like this in pivot table;

Year,Month,amount

Yearjanfebmarchaprilmay junjulyaugetc
2013123456789
2014101112131415161718
2015192021222324252627
2016282930313233343536
2017373839404142434445

 

instead i got this:

I used this expression RangeSum(Before(Sum(Amount), 0, ColumnNo()))

yearjanfebmarchaprilmay junjulyaugetc
2013123456789
2014123456789
2015123456789
2016123456789
Labels (1)
3 Replies
Anil_Babu_Samineni

How is your input data set?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Step
Contributor II
Contributor II
Author

assume all are 1, i just add them up per column

Step
Contributor II
Contributor II
Author

YearJanfebmarchaprmayjunjulyaugetc
2013111111111
2014111111111
2015111111111
2016111111111

 

lets assume all are 1