expression?

[Anonymous]

Hi all,

i am facing an issue with task

i have three field like if select any date it show previous week total sales. like i select 9/8/2018 it will show 1/8/2018 To 7/8/2018 total sales

Date            Product      Sales

1/8/2017        Toys           200

2/8/2017        Toys           200

3/8/2017        Toys           200

4/8/2017        Toys           200

5/8/2017        Toys           200

6/8/2017       Toys           200 

7/8/2017        Toys           200

8/8/2017       Toys           200

9/8/2017       Toys           200

10/8/2017     Toys           200

11/8/2017     Toys           200

11/8/2017     Toys           200

12/8/2017     Toys           200

13/8/2017      Toys           200

14/8/2017     Toys           200

15/8/2017     Toys           200

16/8/2017     Toys           200

17/8/2017     Toys           200

18/8/2017     Toys           200

19/8/2017     Toys           200

20/8/2017     Toys           200

[balabhaskarqlik]

What's the expression you used? And what is your requirement?

[sergio0592]

Hi, it works with :

=sum({<Date={">=$(=WeekStart(Date,-1))  <=$(=WeekEnd(Date,-1))"}>} Sales)

[Anonymous]

thanks for posting its working