The article explains how to Use pivot tables in Excel. The most popular spreadsheet program in the world for over 30 years is Microsoft Excel (opens in new tab). Excel offers tools and features for producing calculations and graphs, unlike presentation software (opens in a new tab), so you can use it for anything from organizing a household budget to tracking a store’s inventory.
One of the most popular spreadsheet programs is Microsoft Excel. Excel is the tool of choice for millions of business users to manage numerical data and gain insights into their processes. In terms of finance and accounting, Excel is a respectable brand; it is often used for financial reporting, to create scenarios for sales forecasts, to see patterns and to organize records. Microsoft provides Excel as a desktop application with Visual Basic programming, as a desktop spreadsheet program, as well as mobile versions for iOS and Android smartphones. The desktop edition of Microsoft Office includes the major version of Excel, which offers over 480 features, many of which are sophisticated Visual Basic routines and instructions. Here is the article to create multiple subtotals in pivot table.
Steps to Create Multiple Subtotal Rows in a Microsoft Excel PivotTable
From the data below, the manager wants to build a table that contains the total and count of sales made by each person in the region. This can be easily done by adding a subtotal to the pivot table. Follow the steps to find out how to create multiple subtotals in the pivot table.
Step 1: The first step is to create a dynamic table for the data.
step 2: By arranging the headers in the PivotTable fields by dragging them as per the requirement, the data will be projected as given in the image.
step 3: Be in the data and go to the PivotTable Analysis Tool tab >> in active field group >> select field settings.
Step 4: A field settings dialog appears up. Under that, select Subtotals and Filters.
Step 5: Under Subtotals, select custom >> and select the subtotals you want to display in the table. In this case, I want to display the sum and count in subtotals. and click OK.
Step 6: After clicking OK. You will get the necessary subtotals in the pivot table.
Conclusion
Here they are final from our article how to create multiple subtotals in pivot table in Excel. We advise you to try the free, restricted, online-only version of Microsoft Excel at office.com if you are new to spreadsheets. This comprises most of the important functions of Excel. The effort required to master Microsoft Excel is worth it because it is a very practical tool. It’s an obvious choice if you need a spreadsheet tool because of its wide use in business. The article is now complete and you know how to add Subtotals and Total Row in a Table in Excel.