Rangesum by dimension

[kirsten_dc]

Hi all,

I have some problems with the following table:

 

I have the two dimensions 'WeekNumber' and 'Branch' and some expressions.
In my last expression I want to show the cumulated sales per 'Branch' until this 'WeekNumber'.

I used this formula: 

RangeSum(Above(total Sum({$<gYear={$(=Max(gYear))}>}fvGrossSales) , 0, gWeek))

As you can see, it cumulates everything without regarding for the branches. I already tried using aggr() but I do not get the right solution.

Any advices?

Regards 
Kirsten

[Brett_Bleess]

Kirsten, I am afraid I am not a Set Analysis guru myself, so the best I have is a Design Blog post that has some info and some additional posts related to different features of Set Analysis, so hopefully they may help you figure it out:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

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

My post will also kick things back up in the list too, so someone else that is better at this may see things and have some direct ideas on where things are going wrong too.  Sorry I am not more help to you on this one.

Regards,
Brett