Comparison between current week day and previous week day

[VishalWaghole]

Hi friends,

I want

Comparison between current week day and previous week day.

Means if i select current monday then i want current mondays data with respective previous monday.

how can calculate it.

Regards,

Vishal

[Gysbert_Wassenaar · Accepted solution]

Suppose you have a field MyDate that contains a date and Sales that contains sales amounts. If you select a date then sum(Sales) will return the sum of the sales for that day. Then sum({<Mydate={'$(=only(MyDate)-7)'}>}Sales) will return the sales of a week (7 days) earlier.

[VishalWaghole]

Thanks Gysbert