Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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