We're going to add a pivot table view into the analysis. Normally, when you add an attribute and a measure column in the Criteria tab, the title and table views are added to the compound layout of the analysis. But if you've already created a hierarchy column in the repository, you have an option to select that column. If a hierarchy column is added, then the compound layout will consist of the title and pivot table views.
We're going to add these columns into the analysis in the Criteria tab as shown in the following screenshot:
Product
: Hierarchy columnYEAR
: Attribute columnDollars
: Measure
When you click on the Results tab, you'll see that two views are automatically added to the Compound Layout. As usual the Title view is added. You'll also find the Pivot Table view.
We need to click on the Edit View (pencil sign) button, to open the pivot table view editor so that we can customize the default pivot table view content. By default, the
Product...