Filter on chart

Hi,

I have a simple chart showing dates and sales.

I want to display everything but the current date figures.

If I try to use the filter window, but only filters using a fixed date, not a function.

I need to do this automatic without providing the current date.

Any ideas are welcome!

M.