Pivot Table and Tabular View are similar in many ways, but are different in the following respects:
- Pivot Table is a more powerful tool.
- Tabular View is simplified and convenient for those who would like to add data column-by-column.
|Is it possible to ...||Pivot Table||Tabular View|
|...drag and drop data from the cubes?||Yes, using the Content Editor or the data explorer||Yes using the data explorer|
|...remove measures/dimensions?||Yes, using the Content Editor with one click||Yes, using the column associated context menu|
|...list measures on rows?||Yes||No|
|...explore data by expanding a hierarchy?||Yes||No. To explore data, add a column with a new granularity level|
|...easily retrieve data from the cube?||Yes, using dimensions, hierarchies and levels||Yes using levels|
|...avoid subtotals in the grid?||Yes, using context values or specific MDX||Yes|
|...display subtotals in the grid||Yes||No|
|...sort by measure value||Yes, the sort will be non-breaking: i.e. it will take into account the hierarchy structure||Yes|
|...sort by dimension caption||No, it is necessary to switch to column view to sort||Yes|
|...switch to Tabular View from Pivot Table and vice versa||Yes||Yes|