My company has a sales journal spreadsheet which pulls its data straight from the ERP system. I've created pivot tables for my reports which break down all sales by week, month, quarter and year.
My problem is that if I apply a filter to the sales spreadsheet, my pivot table ignores what I've filtered and shows ALL the data.
How can I get the pivot table to recognize the filtered results?
Thank you in advance.
Bookmarks