WTD AND PWTD CALUCLATE

[panipat1990]

Dear Team,

I stuck a requirement.i Want to Achive WTD AND PWTD IN EXPRESSION WITH SET ANALYSIS.

I achieved WTD Using this expression

Sum({<[Fiscal Year]=, [Fiscal Month]=, [Day Number], Link_Date={">=$(=Date(WeekStart(Max(Link_Date)),'DD/MM/YYYY'))<=$(=Date(Max(Link_Date),'DD/MM/YYYY'))"}>} Sale)

But i want to PWTD Means Previous week WTD.How is Caluclate. Kindly help me for solving

[MK_QSL · Accepted solution]

Try

Sum({<[Fiscal Year]=, [Fiscal Month]=, [Day Number], Link_Date={">=$(=Date(WeekStart(Max(Link_Date),-1),'DD/MM/YYYY'))<=$(=Date(Max(Link_Date)-7,'DD/MM/YYYY'))"}>} Sale)