# How to Add Running Total in a Pivot Table

A pivot table is a master tool for data analysis, itβs that flexible and powerful.

One of the things which I like about a pivot is we can easily add running total into it, which can further help us in an analysis.

Today, in this post, Iβd like to share a simple step process to add a running total in a pivot table.

## Whatβs a Running Total?

Itβs a cumulative total which includes the past total as well. For example, if we have month wise data from Jan to Dec, a running total will show you YTD total every month.

We can use a running total to measure complete growth against the target.

NOTE: Pivot Tables are one of the INTERMEDIATE EXCEL SKILLS.

## Steps to Add a Running Total in Pivot Table

Adding a running/cumulative total requires simply few clicks and here are the steps to do it.

• Right click on it and click βValue Field Settingβ.
• Now, you have βValue Field Settingβ window.
• Go to βShow Values Asβ tab.
• From βShow Values Asβ drop-down list, select βRunning Total Inβ.
• Click Okay.

Now we have a running total in the pivot table with a cumulative total in every month.

Note: While adding running total make sure that pivot table sorted in a right way. If we want to add it from Jan to Dec then you the values must have sorted from Jan to Dec.

## Different Ways to Add a Running Total in a Pivot Table

Here are some examples of adding a running total in different ways.

### 1. Start Running Total from Zero

Someone asked that how can we start total from a zero. Well, for this we just need to make a small amendment in our source data.

• First of all, in the source data we need to enter a dummy entry with zero value.

### 2. Percentage Running Total

We can also use the percentage of running total instead values and here are the steps.

• First of all, right click on total column and open "Value Field Setting".
• After that, go to βShow Values Asβ tab and select select β% Running Total Inβ from the drop down.
• Click OK.

### 3. Running Total with Grouped Dates

But we can fix it using a helper column and here are the steps.

• First of all, go to your source data and enter a new column after the date column.
• After that, name that column βQ-Mβ and enter the below formula:
`=βQtrβ&ROUNDUP(MONTH(A2)/3,0)&β-β&TEXT(A2,βMMβ)`
• Now, refresh your pivot table and remove both the βQuartersβ and βMonthsβ column fields and add column "Q-M".

### 4. Running Total in a Pivot Chart

In the above example, we have a pivot chart along with the pivot table to show the trend of values increasing month by month.

## Conclusion

By adding running total to a pivot table we can track amount/values cumulatively, which is quite useful while tracking sales, budgets, interest values, etc.

One final thing which I wanted to share with you is that running total changes when sort the pivot table.

I hope this tip will help you use pivot tables with full power and now tell me one thing.

Have you ever tried to apply a running total before?

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ο¬nd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

### 11 thoughts

2. I have spent the better part of several hours trying to understand why my running total was not working. One thing that every article failed to mention is that running total must use a date for the base. I was trying to setup a pivot table for YTD payroll. Instead of using a Date column, I was using a Check Num column. All my checks are generated separately and sometimes I can get two checks on the same date – a regular check and then a benefit check (for phone) or a bonus check. Each check has it own YTD totals, so I was trying to use running total for YTD income and deductions and use the check number as the Base. It doesn’t work. Why can’t the base be any sequential series (date, check number, etc) for running total?

3. Can you please send the sample file for”Different Ways to Add a Running Total in a Pivot Table”

4. Thanks Bro…? Love Your Work.

5. thank you .. used this in an overtime report today

6. Hi! Any way to show, in one column the monthly total and, in another column, the cumulative value?