If you wanted to create a Pivot Table that displays the orders with the dimensions by Year, by Salesperson, by Product Category $($in that hierarchy order$)$ and with the measures of average Quantity and average Total Sales Amount for orders in a given Year for a given Salesperson within each Product Category, how would you set that up in the Excel Pivot Table pane?

In other words, what fields would be your dimensions in the Rows, which fields would be the measures in the Rows, and what Value Field Settings would you set for the Values?