In these two tutorials (two parts) you will learn a few cool tips regarding pivot tables:

1) To fill the empty values with zeros:Right click the base data field (circled below)

Select Table Options…
Type 0 in the empty cells, show (circled below)

Click OK.

The pivot table now should have replaced the blanks with zeros.

2) To hide the Totals column:

Right click the base data field (“Sum of Actual FTE” shown above)
Select Table Options…
Uncheck Grand Total for Rows (circled below)

The totals column should now have been removed.

3) To add a hidden filter to the pivot table:Drag the field that contains the filter into the hidden data filter area (ie – Org unit level 04)

Click the down arrow to select the org unit filter. Select the required filter (ie – Sport And Recreation)

The pivot table now shows only those positions in Org unit level 04, Sport And Recreation.

4) To show only selected position titles:

Click the down arrow to select the Position Title filter

To make selection easier drag the list outwards so more positions are visible

If there are many values in the list and you only want a few, start by un-checking Show All (shown below) to deselect all values

Select the positions you wish to show in the table. (ie – Athletes and Managers)
Click OK

The pivot table should now only contain Athletes and Managers.

5) To show percentages of position type for each position:

Right click the base data field (in this case “Sum of Actual FTE”)
Select Field Settings…

Click Options > >
Select % of row for Show data as
Click OK.

Note: In this list there are also options for % of column and % of total with the latter being very useful.

The pivot table now shows percentages but there may be error values for the rows that have no positions (as you can’t divide by zero!).

6) To remove errors from the pivot table:Right click the base data field (in this case “Sum of Actual FTE”)
Select Table Options…

Enter 0 in the For error values, show box
Click OK.

All errors should now be replaced by zeros.