If you are unable to create a new account, please email support@bspsoftware.com

 

displaying all the prior week from current week/previous week from currentdate

Started by lalitha.nov20, 15 Nov 2013 12:23:12 AM

Previous topic - Next topic

lalitha.nov20

Hi All
i have requirement where i need to display all the prior week in the value prompt from he current week.

week starts on saturday , so the current date is thrusday, then i need to show all the prior weel from previous week.

i was able to fetch the current week but unable to fetch the previous week.

lastperiods(14,item(filter([Labor].[Date].[Hierarchy - Fiscal Year].[Date],[Labor].[Date].[Hierarchy - Fiscal Year].[Date].[Current Date Flag]='y'),0))

can you please let me know how to go about it

Thank you,
Lalitha