How to always display last 7 days in straight table? [Newbie question]

[#1]

Dear all,

Have the below straight table.  I would like that irrelevant of what the user select in the various selection fields .... the straight table always displays the last 7 days from today.  How can this be achieved?

Day	Date	Target	Actual	%
Tue	03-06-14	100,000	66,175	66%
Wed	04-06-14	100,000	68,473	68%
Thu	05-06-14	100,000	59,889	60%
Fri	06-06-14	100,000	51,023	51%
Sat	07-06-14	0	52,763	0%
Mon	09-06-14	100,000	28,365	28%
Total	Total	500,000	326,688

Thanks

Alex

[tresesco]

Use set analysis in expression like:

=Sum({<Date={">=$(=Date(Today() -6))"}>} AmountField)