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)
Can you please post some sample data and expected output?
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