Pivot tables in excel
A pivot table is a [table] of statistics that summarizes the data of a more extensive table (such as from a [database], [spreadsheet], or [business intelligence program]. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.
Pivot tables are a technique in [data processing]. They arrange and rearrange (or “pivot”) statistics in order to draw attention to useful information.[for more details please go through this link]
and if you are solving the same problem with excel functions and pivot table you will get to know it is easier to solve than the use of functions. lt’s only drag and drop of dimensions and measures.
A Pivot Table is used to summarize, sort, reorganize, 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.