How to remove subtotals in pivot table in Excel

Pivot tables are one of the most useful tools in Excel for summarizing and analyzing data. Pivot tables create summaries of data that count, sum or average the values in columns. You can use create a pivot table on a set of data to quickly understand the nature of the data and to analyze it. When aggregation is done on multiple columns, subtotals are added to the pivot table. You may want to remove the sub-totals as they are not required in the context of the data.