Last week data - in the attachment i need to display only last week data in my table i.e (ex :12-01-2014 t0 18-01-2014)

[#1]

its urgent

[Nicole-Smith]

You need set analysis like the following:

{<YourDateField={'>=$(=weekstart(today(),-1))<=$(=weekend(today(),-1))'}>}

So your expression should look something like:

sum({<YourDateField={'>=$(=weekstart(today(),-1))<=$(=weekend(today(),-1))'}>} Sales)

[#3]

Hi

you can as well use calculated dimension

Best regards

Chris