In this Pivot Table, the Dept field is used for a Report Filter. How - ProProfs Discuss
Topics-
Products +
     

In this Pivot Table, the Dept field is used for a Report Filter. How can you get all of the different departments to automatically display on their own separate sheet tabs at the bottom of the workbook?





A. You would need to view each department as a separate Pivot Table first, then copy the worksheet to its own tab
B. Options contextual tab, Options icon, Show Report Filter Pages, OK
C. Display all departments, Options contextual tab, Move Worksheet icon, choose \New Worksheet\, OK
D. Design tab, Move Pivot Table icon, \Move to Individual Worksheet\, OK
E. I don t know the answer to this question.

This question is part of Excel 2010 Skills Assessment
Asked by Carlson, Last updated: Jun 04, 2018

+ AnswerRequest Answer
...

1 Answer

carlson

Carlson

Answered on Mar 24, 2018

Options contextual tab, Options icon, Show Report Filter Pages, OK
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.