pivot table count unique values mac excel 2013

Click the triangle to the right of the column on which you want to filter, then select Custom.

(Create the AutoFilter as you normally would in your version of Excel.) Excel is smart enough to know that the AutoFilter should not apply to the blank column, but instead does its work on the rows that make up the PivotTable. To apply an AutoFilter after the PivotTable is created, all you need to do is select the column to the immediate right of the PivotTable and then create the AutoFilter.

Another way is to go ahead and create the PivotTable, but then apply a filter to the PivotTable to remove those items with a zero value. One way, obviously, is to remove all the zero-value items from the data used to create the PivotTable. There are a couple of ways you can handle this situation. William wonders if there is a way to display in the PivotTable only parts with usage greater than zero. Some parts have not ever been drawn upon and hence the usage is zero. William has a PivotTable based on parts drawn from a store for a particular piece of equipment.

Pivot table count unique values mac excel 2013