Which Excel PivotTable attributes should you use?

Question Set 1

DRAG DROP

You are a Dynamics 365 administrator. An Excel template with a pivot table is created for opportunities by a manager.

When a salesperson opens the Excel template in the My Opportunities view, they observe the following issues:

– The salesperson can view information for all salespeople.

– The salesperson does not see their current data.

You need ensure the salesperson can only see their information.

Which Excel PivotTable attributes should you use? To answer, drag the appropriate attributes to the correct settings. Each attribute may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

View Answer

Answer: