Set Analysis For calculating Last 4 weeks total

[#1]

Hi experts,

I am stuck in writing an expression for calculating the last 4 weeks total customers.

I have a data set like below

I want to display the chart which shows me week wise total customers. But the total customers must be calculated based on last four weeks. This means result should be

Week 1 - Total Customer=4

Week 2 - Total Customer=11

Week 3 - Total Customer = 18

Week 4 - Total Customer = 25

Week 5 - Total Customer= 28 and so on

Please help me in writing the set expression for this scenario.

Appreciate your help.

[#2]

None of the solution specified is working. Can anybody please suggest any other solution?

Thanks,

Ruchika

[mato32188]

Hello Ruchika,

try RangeSum ( above (total Count (Customers) , 0, 4) )

BR

M

[VishalWaghole]

Hi Ruchika,

PFA Qvw application.

Hope it will solve your problem.

-- Regards,

Vishal Waghole

[#5]

Thanks for the solution Vishal.

But the defined solution will only display last four months data. I want to display all the weeks prior to the selected week. So if I select 'Week 15' from listbox, then it should show all weeks data from 'Week 1' to 'Week15'. Also these must be aggregated from prior four weeks data.

So in your example, If I select 'Week 15' then Week 1 to 15 must be displayed with rolling four weeks data for each week.