Pivot Table and Tabular View

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

For more details, please refer to Pivot Table and Tabular View reference pages.