I am implementing rolling three month dashboard .

[#1]

Hello Friends,

I am implementing Rolling 3 months procedure in my dashboard where my fiscal year is from April to March.

my date is [Posting Date] and i want to calculate rolling 3 month Amount .

What condition should i use..

Thanks and Regards.

[er_mohit]

See the attached file

[er_mohit]

You can use Farmula for expression side on the basis of date also used

like this

sum({<PostingDate = {">=$(=MonthStart(Max(PostingDate), -2))<=$(=MonthEnd(Max(PostingDate)))"},Year=,Month=>}Sale)

[#4 · Accepted solution]

Hi Try This Set analysis hope it will help

=sum({<PostingDate={'>=$(Vrolling3)<=$(vMaxDate)'},month=,year=>}Amount)

Variables:

Vrolling3 : =Date(MonthStart(vMaxDate,-2),'DD/MM/YYYY')

vMaxDate : =Date(max(PostingDate),'DD/MM/YYYY')

[#5]

Thanks All For Helping me out...