# Why is sum not working in pivot table?

## Why is sum not working in pivot table?

When you have a pivot table that counts instead of sums, it is caused by one of three reasons. Excel expects your numeric data to be 100% numeric. If you have a dataset with 50,000 rows of numbers and one blank cell in the middle, the pivot table will count instead of sum. This will fill the blank cells with zero.

How do I show a running total in a pivot table?

Running Total in Pivot Table

1. Once you create a pivot table, select any of the cells from data column.
2. Right click on it and click “Value Field Setting”.
3. Now, you have “Value Field Setting” window.
4. Go to “Show Values As” tab.
5. From “Show Values As” drop-down list, select “Running Total In”.
6. Click Okay.

How do you do a cumulative total in a pivot table?

Steps to make this pivot table

1. Create a pivot table.
2. Add Date field to Rows area, group by Months.
3. Add Sales field Values area. Rename to “Total” Summarize by Sum.
4. Add Sales field Values area. Rename to “Running” Show value as running total. Set base field to Date.

### How do you calculate cumulative total in Excel?

Create a running total formula. In our sample Excel workbook, let’s say you want a cumulative total posted in column C. In cell C1, you would type =SUM(\$B\$2:B2). This creates the necessary relative reference point (B2) and absolute reference point (\$B\$2) for your running tally.

How to calculate pivot table running total in Excel?

Pivot table running total Pivot tables have a built-in feature to calculate running totals. In the example shown, a pivot table is used group data by month and show both the monthly total and running total over a 6-month period.

How does a pivot table work in Excel?

Pivot tables have a built-in feature to calculate running totals. In the example shown, a pivot table is used group data by month and show both the monthly total and running total over a 6-month period. The source data contains three fields: Date, Sales, and Color.

#### Can you use grand total in pivot table?

The Grand Total for Rows has been turned on, and Grand Total for Columns is turned off. In the April column, you can see that 1,979 units were sold in 2014, after Food Franchise ordered. You can use running totals in pivot tables with a single field in the Row area, or multiple fields.

How to calculate running total of quantity in Excel?

To calculate a running total of quantity, for each Customer, over the three months, we’ll change the Qty to a custom calculation. We’ll base the running total on the Date field, so the totals accumulate across the Month columns. Right-click one of the cells in the Values area, and click Show Values as