Last 5 week timestamp in calculated dimension

[deepakkrish]

Hi,

I have a date filed called Timestamp , Timestamp fields is locked in my sheet.

So based on the selected timestamp I have to show previous 5 week trends.

I am using two expression one is applicable first 6 month and other one is applicable for july to this monday. can you help me to achieve this ?

if I get 5 week trends in dimension it would be easy I think

Regards,

Deep.

[deepakkrish]

@sunny_talwar 

[deepakkrish]

@swuehl  

[deepakkrish]

=if(TimeStamp>=vMxfivedate and TimeStamp<=vMxYear, TimeStamp)

I tried this formula as well ,It's working if i clear the locked field.

How to show 5 weeks trend from the selected date

Regards,

Deep.