Search for courses or lessons
Redeem a coupon
Start free trial
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?
Hold down the CTRL key and select the additional categories
Go to PivotTable Options > Totals & Filters > Check the “Select Multiple Items” box
Click the “Select Multiple Items” checkbox at the bottom of the filter window
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?
Uncheck the “Select Multiple Items” checkbox, then select Canned Beer
Check “Canned Beer” and uncheck all the other items
Check the “(All)” checkbox, uncheck the “(All)” checkbox, and select the “Canned Beer” checkbox
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?
Go to PivotTable Options and choose to display field “Down, Then Over”, using 2 report filter fields per column
Manually drag the filter fields to the location you want to see them
Go to PivotTable Options and choose to display field “Over, Then Down”, using 3 report filter fields per row
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement