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

Accumulated sum based on dimension

I'm trying to get the accumulated aggregate sum per each FiscalMonthYr but instead I am getting the aggregate sum in total.  How can I write the syntax so that it gives me the accumulated sum per each FiscalMonthYr instead of the total accumulated sum for all FiscalMonthYr combined?

 

I'm using this formula: 

=AGGR(RangeSum(Sum({$<InvoiceType={'903','900'}>}TOTAL TransactionAmount)*-1),FiscalMonthYr)

 

2 Replies
Saravanan_Desingh

Can you please post some sample data and expected output?

Brett_Bleess
Former Employee
Former Employee

The following Design Blog post may be of some assistance on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.