Create hierarchies for the order dates and product categories as follows so you can easily find information about a specific product sale on any date: a. Use the Manage option on the Power Pivot tab to display the Data Model inDiagram View.
b. Create a new hierarchy and use Dateas 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 Productas the hierarchy name.
e. Add the Category and Description fields in that order to the new Product hierarchy, and close the Power Pivot window.
f. Remove the fields from the Columns and Rows boxes.