how to show data of last 7 days in bar chart

[#1]

Hi,

I have an order table with a field OrderDate, a field Units and a field Price.

I created a bar chart and used OrderDate as dimension and sum(Units*Price) as measure.

The bar chart now shows all the order dates and the sum of Unit*Price for each day.

What I want to achieve is, that the bar chart only shows the last 7 days before today.

What is the best way to achieve this?

[Rupa]

Is it true that this set analysis will only work with measure and not as dimension?