Question

Using the Elecmart Sales file from this section, experiment with slicers as follows.
a. Create a pivot table that shows the average of TotalCost, broken down by Region in the row area and Time in the column area. Then insert two slicers, one for Region and one for Time. Select the West and NorthEast buttons on the Region slicer and the Morning and Afternoon buttons on the Time slicer. Explain what happens in the pivot table.
b. Create a pivot table that shows the average of TotalCost, broken down by Region in the row area and Time in the column area. Insert a Day slicer and select the Sat and Sun buttons. Explain what averages are now showing in the pivot table. Verify this by deleting the slicer and instead making Day a report filter, with Sat and Sun selected.



$1.99
Sales0
Views31
Comments0
  • CreatedApril 01, 2015
  • Files Included
Post your question
5000