Objective/usefulness: To explore higher and lower information levels within the same hierarchy/dimension or across other ones. Proceed as follows:
- Right click on Subcategory Video Equipment | Drill | Down | Item. as shown in the next screenshot:
- A new Report executes with the item detail for such Subcategory.
- Pivot the item back to the rows to remove the cross-tab.