The file is in Excel 2007 format, and is zipped. Hello, I am trying to add sum and a count w/in the pivot table but the custom field is disabled. Chose suitable field names to join with your main table. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Bottom line: Learn why the pivot table date group feature is disabled, grayed out, or does not work, and a few quick tips for finding the problem. Custom Calculations enable you to add many semi-standard calculations to a pivot table. Excel pivot tables provide a feature called Custom Calculations. Custom Visuals Development Discussion; cancel. outer fields in an Excel pivot table automatically show subtotals. To quickly display or hide the current subtotal, right-click the item of the field, and then select or clear the check box next to Subtotal "