Skip to main content

How to view how many patients live in each suburb or postcode

Start with exporting your Patient List to Excel.

Don't apply any filters to the report if you want to view numbers for all patients. Alternatively, narrow the search range to patients with appointments or transactions in a particular date range.

Select the Export Button and open the spreadsheet in Excel.

Select the column header to highlight the entire column for either the Suburb or Postcode, depending on your preference. Only select one column header.

Go to the Insert menu and select Recommended Pivot Tables.

You will be taken to a new sheet within the spreadsheet showing a pivot table.

On the right-hand side, drag the suburb (or postcode) from the Field Name section into the Values section.

You should see a table showing how many patients live in each suburb.


Filtering patients by postcode

The Patient List cannot be filtered by postcode. To list or count the patients in a particular postcode, export the Patient List to Excel and filter it there.

  1. Export the Patient List to Excel using the steps above, and open the spreadsheet.

  2. Select the header row, go to the Data menu and select Filter.

  3. Select the drop-down arrow on the Postcode column header.

  4. Untick Select All, then tick the postcode (or postcodes) you want to see.

  5. Select OK. Excel now shows only the patients in those postcodes. The row count appears in the bottom left of the Excel window.

Did this answer your question?