Can someone please point out the reason and possible solutions? I'm running a set of data via power query and has dumped them into a Pivot Table via Power Pivot . 1. Regards, Wendy 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. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Video: Pivot Table Subtotals for Inner Fields. To experiment with the pivot table subtotals shown in this example, you can download the Pivot Table Custom Subtotals Sample workbook. For outer row labels in compact or outline form, you can display subtotals above or below their items, or hide the subtotals, by doing the following: Skill level: Beginner The date grouping feature of pivot tables is a great tool that can save us a lot of time. By using Custom Calculations, for example, you can calculate the difference between two pivot table cells, percentages, and percentage differences. The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. 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. In the Filed Setting the Custom option is greyed out . 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! Otherwise, it might be a one-time glitch. (Tips.Net) When I select the 'INSERT' button the 'pivot table' is greyed and I cannot create a pivot table. Hello, I am trying to add sum and a count w/in the pivot table but the custom field is disabled. outer fields in an Excel pivot table automatically show subtotals. Chose suitable field names to join with your main table. I need them to be in the same row. 2. You can then use the new field with the A & B values as your first dimension and use subtotals on … Custom Visuals Development Discussion; cancel. 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 … In such a case, you can follow the steps below to Add Subtotals in Pivot Table. A simple method would be to create an inline Table using the Source field and giving the 'A-' records a value of 'A' and the remaining 3 a value of 'B'. Add Subtotals in Pivot Table. 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. 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. ... Poewr pivot new date table greyed out ‎03-14-2019 07:24 AM. 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 "