Accumulation is not coming correctly with 2 dimensions

[Anonymous]

Hi Qlik Guys,

I'm new to the qlik.

From last few months i'm facing the below problem.For single dimension i have achieved the straight table as i want but when i'm adding second dimension the calculated measures not working.

For Single dimension Accumulation:Working

Year-Month-Week	Carry from Last week(s)	Planned Task	Closed In Time	Closed Old	Moved to Next week (Pending Tasks)
2018-jun-W24	0	8	4	0	4
2018-jun-W25	4	5	5	4	0
2018-jun-W26	0	6	2	0	4
2018-jul-W27	4	9	1	3	9

here Carry from last week(s) and Moved to Next Week are calculated fields

Moved to Next week = (carry From Last Week(s) +Planned Task) - (Closed In Time+Closed Old)

Carry From Last week(s)= above value of ' Moved to next week'........Range(sum(above())) function i have used here

Still here i getting exact value what i want but when i want to add the task users dimension field then the values are not coming correctly because of above function is used in the table .Please anyone suggest me here.

Output Coming like this: Not Working

Year-Month-Week	User	Carry from Last week(s)	Planned Task	Closed In Time	Closed Old	Moved to Next week (Pending Tasks)
2018-jun-W24	Harry	0	3	1	0	2
2018-jun-W24	John	2	5	3	0	4
2018-jun-W25	Harry	4	4	2	2	4
2018-jun-W25	John	4	1	3	2	0
2018-jun-W26	Harry	0	3	2	0	1
2018-jun-W26	John	1	3	1	0	2
2018-jul-W27	Harry	2	5	1	3	3
2018-jul-W27	John	3	4	1	0	6

But i Want like this:Expecting this

Year-Month-Week	User	Carry from Last week(s)	Planned Task	Closed In Time	Closed Old	Moved to Next week (Pending Tasks)
2018-jun-W24	Harry	0	3	1	0	2
2018-jun-W24	John	0	5	3	0	2
2018-jun-W25	Harry	2	4	2	2	2
2018-jun-W25	John	2	1	1	2	0
2018-jun-W26	Harry	2	3	2	0	3
2018-jun-W26	John	0	3	1	0	2
2018-jul-W27	Harry	3	5	1	3	4
2018-jul-W27	John	2	4	1	0	5

Thanks and Regards

Subash

[sunny_talwar]

May be wrap around your RangeSum() expression with Aggr()

Aggr(...YourExpression..., User, [Year-Month-Week])