Adding a permanent filter for the previous month

[scass77]

Hi guys,

I have created a pivot table chart, showing customers/total sales.

I want the chart to always only show the sales for the previous month. 

is there a formula I can use to do this?

Many thanks!

[G3S]

sum(if(month=month(yourdatefield)-1, sales))