Question

short note about simple table, excel table and pivot table​

Answer 1

Straight tables allow interactive sorting, sorting is fixed by the sort order property in pivot tables. Pivot tables allow you to have dimensions displayed on both rows and columns.Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.