You can now see that there were 2,595 units sold to Corner Cabin, Also, if there's anĮrror in any month's results, it will carry down through the remaining Note: If you select a base field that isn't in the row or columnĪrea, all the results will show an #N/A error. Right-click one of the cells in the Values area, and click Show.We'll base the running total on the Date field, so the totals accumulate The three months, we'll change the Qty to a custom calculation. To calculate a running total of quantity, for each Customer, over We can see the Grand Total for each month, and for each Customer.Ĭurrently, there are only Normal calculations in the pivot table, Year and Customer are in the Row area, Month is in the Column area,Īnd Quantity (Qty) is in the Values area. In the pivot table, Date has been grouped by year and month. Set up the Pivot Tableīelow is a pivot table which contains monthly sales figures for 3Ĭustomers. Watch this video to see the steps for creating a pivot table in ExcelĢ013, then changing the values to show a running total. Total calculation, to show the current running total amount, dividedīy the grand total. In Excel 2010 and later versions, you can also use the % Running Tutorial, we'll focus on the Running Total custom calculation. To create a running total, use the CustomĬalculation feature in a pivot table. Get the Sample Files Create Running Totals in Pivot Table

Grandtotal mac