Logo
3

Benicio wants to isolate sales for each product. Insert a slicer as follows to filter the PivotTable: a. Insert a slicer based on the Product field.

Full question: Benicio wants to isolate sales for each product. Insert a slicer as follows to filter the PivotTable:

a. Insert a slicer based on the Product field.
b. Move and resize the slicer so that it covers the range F3:G12.

ramesrames asked 2 years ago

·

oh

davidmacago commented a year ago·

Answers

2

a. Go to insert tab. Under filters group, click Slicer. Select Product checkbox and hit ok.
b. Move and resize the slice to F3 through G12

davidapdavidap answered a year ago

Post your answer

Recommended Books

Reading books is a great way to learn. Here are some of the books we recommend.