Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
irmantas
Contributor III
Contributor III

How use RangeSUM in Pivot to SUM all before

Hi All,

I have a problem, calculate accumulative sum's for some transactions in PIVOT.

I am using formula  RangeSum(Before(TOTAL sum([UseQTY]),0,ColumnNo(TOTAL)))

I need to calculate all UseTOTAL till some period. I need calculate all periods even before the filter is used.

irmantas_0-1637138106503.png

irmantas_1-1637138526500.png

 

1 Reply
irmantas
Contributor III
Contributor III
Author

Or I need use other expression?