Uses of a pivot table:-

A pivot table helps users answer business questions with the tiniest step. Common pivot table uses include:

• To calculate sums or averages in business concerns. For example, counting sales by unit or area.
• To show totals as a percentage of a whole. For example, comparing sales for a detailed product to total sales.
• To develop a list of unique values. For example, showing which states or countries have ordered a product.
• To make a 2x2 table summary of a complex report.
• To determine the maximum and minimum values of a dataset.
• To query data directly from an online analytical processing (OLAP) server.