1. 1

    You’ve added a new filter to filter your Sales Category on your PivotTable. When you go to use it, you notice that you can only filter by a single category, but you’d like to select Bottled Beer, Canned Beer and Draft Beer. How can you fix this?

  2. 2

    Assume you had a PivotTable filtered as shown below, and you wanted to select only the Canned Beer category. What would be the most efficient method to do so?

  3. 3

    What steps would you need to take to set up your filters to appear as shown below, providing you’d added them to your report filters area in the following order: Category, Class, Week, POSChitHour and POSChitMinute?