$9.)$ Create hierarchies for the order dates and product categories as follows so you can easily find information about a specific fabric sale on any date:

a$.$ Use the Manage option on the Power Pivot tab to display the Data Model in Diagram View.

b$.$ Create a new hierarchy and use Date as the hierarchy name.

c$.$ Add the OrderDate$($Year$),$ OrderDate$($Quarter$),$ OrderDate$($Month$)$ and OrderDate fields in that order to the new Date hierarchy. $($Hint: Do not select the OrderDate$($Month Index$)$ field.$)$

d$.$ Create another new hierarchy and use Product as the hierarchy name.

e$.$ Add the Category and Subcategory fields in that order to the new Product hierarchy, and close the Power Pivot window.

Revise the PivotTable to use the hierarchies you created as follows:

f$.$ Remove the fields from the Columns and Rows boxes.

g$.$ Use the following hierarchies from the $2018-2019$ Orders table in the PivotTable areas:

Date hierarchy: Rows box

Product hierarchy: Columns box

h$.$ Leave the ItemQty field in the Values box.