Even if you try to sort by the date it will treat it as text. When I take the Years and Quarters fields off of the pivot table the Invoice date displays as Jan. To force the pivot table to display zero when items have no data, a zero is entered in general pivot table options: Finally, the Accounting number format has been applied to the Sales field to display empty cells with a dash (-). The CountB field appears in the Values area of the pivot table, and in the field list in the PivotTable Field List. The Calc column depicts the type of calculation and there is a Serial number for each. Sometimes the dates will be automatically grouped by month when you add the Date field as row label in a pivot table as below screenshot shown. We recently updated to Office 2013. The value grid is filtered by the selections for columns and rows. The data worksheet has the date formatted as I would like which is 06/02/18. Consider this Data & a Pivot Table! In the popup menu, click Number Format. Excel pivot tables filter on the values in rows and columns in a pivot table, not the value grid. Calculated Fields can add/ subtract/multiply/divide the values of already present data fields. First I create a Pivot Table, Then drag Dates into Row Section, Duration h:mm to Values Section become Sum of Duration h:mm. Band in Rows and CTC in Values. The problem here is that Excel doesn’t store this value as date or number but as text. PivotTable Fields is a Task Pane associated with a PivotTable. I really want the date to look the way it is in the original data… 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 "