Current Week vs last three week trail

[abhaysingh]

HI All,

What would be the logic for Current week Vs Last three Week Trend..

thanks In advance..

[abhaysingh]

fyi

[ankitaag]

Hi,

Please find the attached app

[ankitaag]

Please go through the app..

This is exactly what you want

Thanks and Regards,

Ankita

[abhaysingh]

Hey Ankita,

i tried but not working

[abhaysingh]

Hey Enrique,

Waiting For your revert..

Thanks

[ankitaag]

What is not working Abhay?

Tha application is working at my end.

Moreover, you don't have values in week for all the InvoiceDate.

Kindly create the week like WeekStart(Invoice Date) as Week

and in the frontend create a variable for vMinWeek = Max(Week)-21

and CuerrentWeek = max(Week)

In the chart expression write =sum({<Date={">=$(vMinWeek} <=$(vCurrentWeek)"}>}Sales)

[tresesco]

Your expression

Sum({ < [Invoice Year]=,  Week  ={">=$(='$(vLast3Week)')<=$(='$(vMaxWeek)')"}>}   [Outstanding Amount])

seems working fine.

Isn't it? Only issue could be if you are selecting other time dimension members as well. You have to just include them too in the set expression like you did for [Invioce Year].

[abhaysingh]

Good to see you after so long...

but when i m selecting month it should give me selected month current week vs last 3 week trend right? but unfortunately it is not giving..

thanks

[ankitaag]

You need to clarify 1 thing, if you select a month and suppose that month has only 1 week..so you need the last 3 weeks of the previous month in comparision or not?

[ecolomer]

Today Ivery busy

Tomorrow I canb  have some time for that.

I'm sorry

Saludos,