I have two reports which shows sales transactions data - one is graph and the other a pivot table. Both reports use the same base table. There are no filters on the reports so it shows all transactions for the last 6 months.

I want to create a dashboard that includes the graph and the pivot table report. However, I want the dashboard to have a fixed date filter that only shows the last 30 days of data i.e. filtering the underlying graph and pivot table to show the last 30 days of order data.

I seem to be only able to add a user filter to the dashboard. Is it possible to add a "dashboard filter" that is not visible to the end user - similar to a report?

Cheers

Sunil