如何在Pivot Table中实现单元格显示为该行Total days的百分比？

Absolutely, your goal is totally achievable! The issue with the built-in "Show as % of row total" or "% of parent row" options is that they’re tied to the pivot table’s automatic row totals, not your custom calculated "Total days" field. That’s why you’re seeing 100% or incorrect overall percentages—those options don’t recognize your custom total as the denominator.

Here’s how to make it work using a custom calculated field:

• Open your pivot table’s field list, then navigate to the "Fields, Items & Sets" menu (usually under the "Analyze" or "Options" tab, depending on your Excel version) and select "Calculated Field".
• In the pop-up dialog, name your new field something clear like % of Total Days.
• In the formula box, enter the calculation using your existing field names. Make sure to wrap field names with spaces in single quotes, like:

  ='Billed Days'/'Total days'
  

  Pro tip: Double-click fields from the list below to insert them directly into the formula—this avoids typos!
• Click "Add", then "OK". Drag this new calculated field into your pivot table’s Values area.
• Finally, format the new field as a percentage: right-click the values, choose "Number Format", select "Percentage", and adjust the decimal places to your preference (e.g., 1 decimal place for 85.6%).

Quick Notes: #

• Ensure your "Total days" calculated field doesn’t have any circular references—this will break the percentage calculation.
• If your pivot table has nested row labels, you may need to tweak the formula to account for the hierarchy, but for a simple single-row-to-Total-days mapping, this method works perfectly.
• If you modify your pivot table’s row structure later, double-check that the calculated field’s formula still references the correct fields.

This approach bypasses the built-in percentage options and directly uses your custom "Total days" field as the denominator, which is exactly what you need.

内容的提问来源于stack exchange，提问作者henry0503