Ignore dimention on pivot table for cumulative horizontal amount montly

[CeciliaPerez3]

Hi!

I'm doing a model where i need show a pivot table with 2 expressions (Sales amount, Accumulated Sales per month)

My expression to get accumulated Sales per month is : =RangeSum(Real, before([Acumulado Real])). 

This expression works perfectly if I don't select months.

I tried before with a set analysis to ignore the selected month but it didn't work.

My problem comes when I select February, the expression only show the accumulated  sales for that month and i need it shows all the accumulated sales where the month is equal or less for selected month.

What do I need to add to my expression ? or Do I need change it?

Attached image with examples.

Thanks in advance

[Brett_Bleess]

Have a look at the following Design Blog post, not sure if using AGGR in your expression will change behavior or not, the only other thing of which I can think would be needing to use Set Analysis, so will provide a link to that too.

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulative-Sums/ba-p/1468010

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

Here is the base URL to the Design Blog area in case you want to search yourself:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett