If all buttons are greyed out, it certainly looks like the workbook is shared or the sheet protected. 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 … 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. You can then use the new field with the A & B values as your first dimension and use subtotals on … Skill level: Beginner The date grouping feature of pivot tables is a great tool that can save us a lot of time. 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'. So far so good however the result in Pivot Table can't do Subtotal? When I select the 'INSERT' button the 'pivot table' is greyed and I cannot create a pivot table. Custom Calculations enable you to add many semi-standard calculations to a pivot table. Hello, I am trying to add sum and a count w/in the pivot table but the custom field is disabled. Regards, Wendy By using Custom Calculations, for example, you can calculate the difference between two pivot table cells, percentages, and percentage differences. Add Subtotals in Pivot Table. 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: Turn on suggestions. (Tips.Net) I'm running a set of data via power query and has dumped them into a Pivot Table via Power Pivot . To experiment with the pivot table subtotals shown in this example, you can download the Pivot Table Custom Subtotals Sample workbook. 2. 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! In such a case, you can follow the steps below to Add Subtotals in 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 only way to tell for certain if a cell is contained within a Table is to click on it and look at the Ribbon. 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. Otherwise, it might be a one-time glitch. This pivot table shows coffee product sales by month for the imaginary business […] Chose suitable field names to join with your main table. Excel pivot tables provide a feature called Custom Calculations. Can someone please point out the reason and possible solutions? http://www.contextures.com/excel-pivot-table-subtotals.htmlThe outer fields in an Excel pivot table automatically show subtotals. The file does not contain any macros. ... Poewr pivot new date table greyed out 03-14-2019 07:24 AM. Video: Pivot Table Subtotals for Inner Fields. In the Filed Setting the Custom option is greyed out . 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. Custom Visuals Development Discussion; cancel. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Depending on your requirements, you may find the need to show Subtotals in Pivot Table. 1. The Subtotals option on the Data menu is normally available for adding or removing subtotals to data tables. The file is in Excel 2007 format, and is zipped. 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 "