how to add multiple rows in excel and keep column totals

First of all, go to your source data and enter a new column after the date column.But we can fix it using a helper column and here are the steps. Now if you look, after a change in the quarter, the running total is starting over again. In the below pivot table, we have grouped dates and create two-row labels from them “Quarters” and “Months”.Īnd, we have also applied running total in the data field. When we add a running total where we have grouped dates there could be a problem, let me show you. After that, go to “Show Values As” tab and select select “% Running Total In” from the drop down.First of all, right click on total column and open “Value Field Setting”.We can also use the percentage of running total instead of values. And once we do that it give a running total starting from zero. Now, go to the pivot table and refresh it.Here our data is starting from Jan’15, and that is why I have used Dec’15 for the dummy entry.First of all, in the source data we need to enter a dummy entry with zero value.

Well, for this we just need to make a small amendment to our source data.

Someone asked that how can we start the total from zero. If we want to add it from Jan to Dec then the values must have sorted from Jan to Dec. Note: While adding running total make sure that the pivot table sorted in the right way.

How to add multiple rows in excel and keep column totals