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. Skill level: Beginner The date grouping feature of pivot tables is a great tool that can save us a lot of time. This will remove the Subtotals for Store#1 and Store#2 and the Pivot Table will only indicate the Grand Total of items sold by both the stores. Regards, Wendy Now, go back to your pivot table, right click any cell in your pivot table, and choose PivotTable Options from the context menu, see screenshot: 4. The file is in Excel 2007 format, and is zipped. So far so good however the result in Pivot Table can't do Subtotal? Chose suitable field names to join with your main table. 2. You can then use the new field with the A & B values as your first dimension and use subtotals on … In such a case, you can follow the steps below to Add Subtotals in Pivot Table. Excel pivot tables provide a feature called Custom Calculations. The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. ... Poewr pivot new date table greyed out ‎03-14-2019 07:24 AM. In the Filed Setting the Custom option is greyed out . Custom Visuals Development Discussion; cancel. If all buttons are greyed out, it certainly looks like the workbook is shared or the sheet protected. 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. Turn on suggestions. I'm running a set of data via power query and has dumped them into a Pivot Table via Power Pivot . 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. Custom Calculations enable you to add many semi-standard calculations to a pivot table. I need them to be in the same row. 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 "