make a applysimple filter that calculates the start date as
the sysdate - the n days (here 10) and end date as sysdate.
this will give you the data related to sales of last n
dates.
You can do it without using value prompt with below steps.
Create a filter on day attribute qualified on ID operator >
and set value to resolve dynamically today – last 10 days.