By using Custom Calculations, for example, you can calculate the difference between two pivot table cells, percentages, and percentage differences. Regards, Wendy This pivot table shows coffee product sales by month for the imaginary business […] Turn on suggestions. Chose suitable field names to join with your main table. 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. Video: Pivot Table Subtotals for Inner Fields. 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 … 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 "