Step-2: Adding Grand Total Column in Source Data Next, we will show you how you can show the Grand Total on the top of the Pivot Table. In the Pivot Table, you can easily notice that the Grand Total is at the bottom of the Pivot Table. we select the Sales and Profit > drag them to the Values group.Īs a result, you can see the Pivot Table.One thing must be noted, in the PivotTable Fields, we mark the Product > drag it to the Rows group.Here, we have created the Pivot Table by following Step-1 of Method-1.After that, we will show grand total on top of the Pivot Table. Using this dataset we will insert a Pivot Table. The following dataset has the Product, Sales, and Profit columns. Showing Grand Total on Top of Pivot Table Read More: How to Use Excel Formula to Calculate Percentage of Grand TotalĢ. Therefore, you can see the Pivot Table is showing Grand Total for rows and columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |