I am using a pivot table to represent a database of ordering information. Since the source information is too large to fit on a spreadsheet, I've created several CSV Files to hold the data, and am linking them together using Microsoft Query.
Each record has CustomerID, Order No, Line No, Product, Date & Quantity. A Customer will place many orders, and within each order there may be several lines.
What I want to be able to do is Filter the pivot table so that I only see those Customers that have an order quantity above e.g. 20,000. If I just displayed CustomerID Vs Quantity, then I'd be wanting to filter on the data area.
Since I'm using a huge CSV File, I've not found a way to filter the data easily before importing it into the pivot table.
I have spend a fair bit of time trying to figure out a way to achieve this, but so far not had any success. Any suggestions would be appreciated.