Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
What would be the logic for Current week Vs Last three Week Trend..
thanks In advance..
fyi
Hi,
Please find the attached app
Please go through the app..
This is exactly what you want
Thanks and Regards,
Ankita
Hey Ankita,
i tried but not working
Hey Enrique,
Waiting For your revert..
Thanks
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)
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].
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
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?
Today Ivery busy
Tomorrow I canb have some time for that.
I'm sorry
Saludos,