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
Product
Hierarchy is created .
3. Drag and drop Market column into Columns
and Sales column into Rows
4. Navigate from Market -> Product Type
-> Product by clicking “+” symbol.
5. If we want to come back from navigation
detail to summary, use “-” symbol.
No comments:
Post a Comment