Pivot Table and Tabular View

Pivot Table and Tabular View are similar in many ways, yet:

• Pivot Table is a more powerful tool.
• Tabular View is simplified and convenient for those who would like to add data column by column.

May I ...	Pivot Table	Tabular View
...drag and drop data from the cubes?	Yes, using the wizard or the data explorer	Yes using the data explorer
...remove measure/dimension?	Yes, using Wizard with one click	Yes, using the column associated context menu
...list measures on rows?	Yes	No
...explore data expanding a hierarchy?	Yes	No, to explore data - add a column with 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, one need to switch to column view to sort	Yes
...switch to Tabular View from Pivot and vice versa	Yes	Yes

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