show just the last week

[#1]

hello,

I am creating a chart that is supposed to show the sales for last week . yet i cannot get the chart to show me how to show just the last week things were sold.

any help will be greatly appreciated

[martin59]

Hello,

You have to use the set analysis :

sum( {<Week={$(=(Week(Today())-1)}>} CA)

[#3]

Had the same problem. Solved it using a calculated dimension:

=if(date([Date])>=date(max(total [Date])-7) and date([Date])<=date(max(total [Date])),date(Date),null())

with "Surpress When Value is Null" option on and the expression:

sum({<[Date]=>}[Sales])

[#4]

Thanks a lot, it helped 🙂

I have another problem, I need to create a chart that shows the sales since last Thursday..

Thanks in advance

[#5]

The calculated dimension must look like:

=if(date([Date])>=date(weekstart(max(total [Date]))-4) and date([Date])<=date(max(total [Date])),date(Date),null())