Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm putting together a report where I need to select a week or dayand be able to compare this to the previous 4 weeks before that.
How can I do this and can I see that in the same graphic?
Thanks!
Current Week
Sum({<Date = {">=$(=Date(WeekStart(Today())))<=$(=Date(WeekEnd(Today())))"}>}Sales)
Last Week
Sum({<Date = {">=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekEnd(Today())-7))"}>}Sales)
For 4 Week adjust accordingly...