Creating Creditor ageing report using Pivot Table showing zero pg 90

In the above report, group >120 does not appear because its total value is zero. To force an item with zero total to appear, follow these steps:

1. Right-click on any cell in the report.

2. A floating menu will appear.

3. Select Field Settings.

4. A dialog titled PivotTable Field will appear.

5. Put a mark in the box on the left of Show item with no data.

6. Click OK

7. The report will refresh with the group >120 now appearing.