Example 2 – Nested Table

In this example you will modify the view from Example 1 – Basic View to show quarters in addition to years. Follow the steps below to build this view.

Show quarters using one of the following methods:

• Drill down on the Year(Order Date) field by clicking the plus button on the left side of the field.
  
  
• Drag the Order Date field from the Data window and drop it on the Columns shelf to the right of the Year(Order Date) field.
  
  

The new dimension divides the view into separate panes for each year. Each pane has columns for the quarters of the given year. This view is called a nested table because it displays multiple headers, with quarters nested within years.