Rolling sum in quarter

[anushahegde]

Hi Everyone,

There is a filter called period which contains all the months.

The requirement is

For any year,

For quarter 1,

If Period = Jan is seleted, then sum (Sales) for Jan should be diplayed.

If Period = Feb is selected, then sum(Sales) for Jan + Feb should be displayed.

If Period= Mar is selected, then sum(Sales) for Jan + Feb + Mar should be displayed.

For quarter 2,

If period = April is selected, then sum(Sales) for Apr should be displayed.

If period = May is selected, then sum(Sales) for Apr + May should be displayed.

If period = Jun is selected, then sum(Sales) for Apr + May + June should be displayed

and so on.

Please help me to know how can I do this.

Thanks in advance,

Anusha.

[big_dreams]

can you share sample working file also..

Regards,

[sunny_talwar]

Is this something you need on the front end of the app or backend scripting?

[anushahegde]

Hi Sunny,

Anything is fine for me.

[Silambarasan1306]

Hi Anusha Hedge,

This is like QTD concept.

Use the below expression in your measure.

Sum({<Period={">=$(=Quarterstart(Max(Period)))<=$(=Max(Period))"},Quarter=,Month=>}Sales)

Now, if you select Q1/Q2, the entire quarter sales will be shown. Select Q1/Q2 and then select month you will get the rolling sum value of sales.