1. Select the columns on which columns you
want to create hierarchy and right click then select the “Create Hierarchy” option.
Eg:
Here we are selecting Market, Product, Product Type
2. Give the name
of Hierarchy
3. Drag and drop Market column into Columns
and Sales column into Rows
Product
Hierarchy is created .
4. Navigate from Market -> Product Type
-> Product by clicking “+” symbol.
5. If we want to come back from navigation
detail to summary, use “-” symbol.
