how to get data on current week?

[#1]

Hi,

I have to show the no of salesitems logged and no of salesitems closed in current week, i,e if user access the file on every Thursday user need to show the data from Monday to Thursday for eg: if I logged on 03/07/2014 the table will show the data from 30/06/2014 to 03/07/2014.

Is it possible. can anyone help me with expression?

I used below but not getting how to change on week.

Dimension: staff
Dimension: Product

expression1: count(distinct(Saleid)
Expression2: =Count({<growns={'Closed','closed'}>}Saleid)

[#2]

Maybe:

Week = {$(=Max(Week))

[SunilChauhan · Accepted solution]

Count({<Date={">=$(=Weekstart(today()))<=$(=Weekend(today())-3)"    },growns={'Closed','closed'}>}Saleid)

[#4]

Thanks. for logged I can use below right?

Count({<Date={">=$(=Weekstart(today()))<=$(=Weekend(today())-3)"    }>}saleid)

[SunilChauhan]

yes thats correct

[#6]

Thanks.