If the option is grayed out—not available—in Excel 2003, then it could be because the data table has been defined as a list. Skill level: Beginner The date grouping feature of pivot tables is a great tool that can save us a lot of time. Custom Visuals Development Discussion; cancel. Regards, Wendy Depending on your requirements, you may find the need to show Subtotals in Pivot Table. The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. In the Filed Setting the Custom option is greyed out . The only way to tell for certain if a cell is contained within a Table is to click on it and look at the Ribbon. http://www.contextures.com/excel-pivot-table-subtotals.htmlThe outer fields in an Excel pivot table automatically show subtotals. I need them to be in the same row. If all buttons are greyed out, it certainly looks like the workbook is shared or the sheet protected. The file does not contain any macros. By using Custom Calculations, for example, you can calculate the difference between two pivot table cells, percentages, and percentage differences. I'm running a set of data via power query and has dumped them into a Pivot Table via Power Pivot . Hello, I am trying to add sum and a count w/in the pivot table but the custom field is disabled. If you try to sort a range of cells that are partially within a table and partially outside a table, you’ll find that the Sort and Filter options are grayed-out and unusable, even though the cells might look completely ordinary! 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 "