We help IT Professionals succeed at work.
Get Started

Excel Pivot Table - Running total that doesn't end at 100%

Ryan McCauley
on
383 Views
Last Modified: 2015-03-04
I've got a dataset in Excel for which I want to display the running total. However, I want the display to end before I get to 100% - see the below image:

Pivot chart example
The right-most data element is for tickets open longer than 10 days (">10 Days"), but I don't want to include that particular value in the display chart, but instead have the chart end at 10 days and the lines end at 96% (or whatever they would end). The problem I'm having is that, when I uncheck the ">10 Days" data element in my pivot table to remove it from display, Excel re-calculates the running total so that the remaining data elements still add up to 100%.

In essence, I guess I'm looking for Excel to calculate the running total as a total of all data in the set, not just what I've chosen to display. If I uncheck items in the pivot table, I want them hidden from display but I want their values still included for the purpose of the summary.

Does that make sense? Is it possible? My initial research tells me it's not, and I'd considered formatting the pivot table properly, copying my data into a new static table and building a standard chart based on that instead. If I can do it inside the pivot chart so that it stays connected, that's ideal though.

If it matters, I'm using Excel 2013.
Comment
Watch Question
Director, Practice Manager and Computing Consultant
Awarded 2014
Top Expert 2014
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE