In the PivotTable Options dialog box, go to click the Total & Filters tab, and then make sure to check Use Custom Lists when sorting option under Sorting section, see … Add Subtotals in Pivot Table. When I select the 'INSERT' button the 'pivot table' is greyed and I cannot create a pivot table. 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 only way to tell for certain if a cell is contained within a Table is to click on it and look at the Ribbon. I'm running a set of data via power query and has dumped them into a Pivot Table via Power Pivot . ... Poewr pivot new date table greyed out ‎03-14-2019 07:24 AM. Regards, Wendy In such a case, you can follow the steps below to Add Subtotals in Pivot Table. You can then use the new field with the A & B values as your first dimension and use subtotals on … The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. Chose suitable field names to join with your main table. Excel pivot tables provide a feature called Custom Calculations. Turn on suggestions. So far so good however the result in Pivot Table can't do Subtotal? Custom Calculations enable you to add many semi-standard calculations to a pivot table. I know how to subtotal the data (w/o it being in a pivot table) but that will put the sum and the count on separate lines. The file is in Excel 2007 format, and is zipped. By using Custom Calculations, for example, you can calculate the difference between two pivot table cells, percentages, and percentage differences. 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. 2. Otherwise, it might be a one-time glitch. 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 "