Pivot Table Pick

I have a pivot table showing sales of items to various customers.

I'd like to be able to switch between showing unit saels and $ sales without having to have separate sheets. Is there an easy way of doing this?

Thanks,
Tim

By 'unit sales' do you mean 'count of sales'? Or is there a separate field in your source data showing a unit sales number?

Hi Gaz, Separate field. One field for $, one for the number of items sold (Unit Sales)

Thanks,
Tim