In a Pivot Table, you can analyze multiple measures across multiple dimensions. A pivot table is a table that contains Measures and Dimensions as Rows and Columns. Pivot Tables facilitate rearrangement of the measures and dimensions to achieve different perspectives of the data.

A table shows data at only one level of aggregation,where as a pivot table can show data at multiple levels of aggregation

Example Query

SALES BY SUB CATEGORIES BY CATEGORIES BY MONTHS BY YEARS

Format Interface