Use Table Drilling
After you create a table, use drilling in the table to expand and collapse the levels within the hierarchy by which you can view different levels of aggregation.
When viewing a table or graph, the dimensions and hierarchies selected on the Hierarchies tab are visible. The top selected level is visible; use drilling to view lower levels.
To drill across hierarchies or dimensions, the levels must be adjacent. Drilling is automatically available for the levels within the predefined hierarchies, but you can also configure drill pairs to drill across hierarchies or dimensions.
To display a table showing Final Shipments History with the ability to drill from customer to item, the columns Customer and Item must be adjacent:
-
On the Layout tab, use the View menu to select Configure Drill Settings.
-
Click the Add Row icon to add a new drill pair.
-
In the Drill From column, select Customer. In the Drill To column, select Item.
With this configuration, you can view the shipments history values by item for each customer in the table.