Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)