Step 1. Open your PurchasePlus Snapshot report in Excel.
Step 2. Highlight all the information in the spreadsheet using [Ctrl + a] on your keyboard and select [Sort & Filter] [Filter]
Step 3. You can now filter the information in the spreadsheet using any column using the [Drop-down] arrow.
You can then select the information you want shown in the Spreadsheet.
In this example, now only Orders from "Food" and "Beverage" departments are shown.
Your Snapshot report has now been filtered.