The PivotTable is a powerful analysis tool in Excel. You can add as many PivotTables as required to the Cube.
Steps for adding and setting up a PivotTable:
Click the Add button in the Objects list of the Cube and select PivotTable.
Click the Edit button in the Objects list to set up the PivotTable.
Click the Add/Remove button in the PivotTable Field List to add fields from the Data Source to the PivotTable, or to remove them.
Via Edit you can specify the field details like Subtotals.
Note
The Virtual Value Field will be added automatically if necessary.
PivotChart
A PivotChart is the visual representation of a PivotTable. Both are connected to each other.
Select PivotChart in the PivotTable Setup to add a PivotChart to the PivotTable.
If Embedded Chart is selected, the Chart will be added directly in the PivotTable sheet. Otherwise, a new sheet will be added for the Chart.
Steps for adding and setting up a PivotTable:
Select PivotChart in the PivotTable Setup to add a PivotChart to the PivotTable.
If Embedded Chart is selected, the Chart will be added directly in the PivotTable sheet. Otherwise, a new sheet will be added for the Chart.
