Hello. I've created pareto pivot charts in Excel 2010; however, I only want to show the top 80%. The tables use the "% Running Total In" selection in the Value Fields Setting dialog box. However, whenever I filter to select only the top 80% line items, the % running total recalculates to total up to 100%. Other than creating the chart "manually", I'm not sure how to exclude the 20%. Hoping it is possible. I've done a fair amount of searching to no avail. Thank you.