Running Totals in Pivot Table

[jplumhoff]

Can I only have one ROW value when using the Running Totals In Function? or is there a way to have multiple Row Values and still have running totals?

 

[Jerry Sullivan]

Hi and Welcome to MrExcel,

You can use the Show Value as option: "Running Totals In" for PivotTables with more than one field in the Rows area, but those values tend to only be useful for the field you designate as your Base Field.

For example, if your Base Field is at the 3rd level of the Row Labels hierarchy, then the running total is just relative to each PivotItem at the 2nd level of the Row Labels hierarchy.

If your Base Field is at the Top level of the Row Labels hierarchy, then the running total will be useful for the SubTotals of that Top Field, but the values associated with lower levels will have ordinary totals, not running totals.

 

[jplumhoff]

Thank you for your reply and your help
but
I have tried the first or Top field in the hierarchy as well as every other row label in trying to understand the running totals. The only way I have been able to make the running total work is to have only one row label in the pivot table so I guess I am still not understanding how the hierarchy works to enable running totals, but I do appreciate your help.

 

[Jerry Sullivan]

If you post a small screenshot to show your desired result, it will help.

 

[JonCG]

Hello, I didn't see a resolution to the question from 'jplumhoff'. I am having the same issue. I need Running Totals by date but it does not seem to work once I have multiple labels. I attached some snips. I am trying to do the Running Totals for Posting Date. But it stopped working once I added more Row labels after Posting Date.

Thank you!