Christine is interested in the performance of Direct sales during the months of April and September, which were good months for sales overall. Filter the PivotTable as follows to show the data that Christine requests:
a. Hide the PivotTable Field list so that you can work with the Sales Type slicer in the range I3:J15, and then use the Sales Type slicer to filter the PivotTable and display Direct sales only.
b. Add a second slicer based on the Date field.
c. Move the Date slicer below the Sales Type slicer and resize it so that its upper-left corner is in cell I17 and the lower-right corner is in cell J30.
d. Use the Date slicer to filter the PivotTable and display April and September orders only.



Answer :

Other Questions