Add field to pivot table

Can you attach what you have so far.

Done. Just removed all data.

You will note, there are duplicates from spelling mistakes but I will fix that later.

using =TRIM(RIGHT(SUBSTITUTE(F3,",",REPT(" ",50)),50)) to get the suburb in the helper column

But this has problems if I have to add the State

Example

13 St johns Avenue, New Town - Returns "New Town" = win
13 St johns Avenue, New Town, Tasmania - Returns "Tasmania" - No ideal
13 St johns Avenue, New Town Tasmania - Returns " Newtown Tasmania - Workable.

You seem to be asking different things in Post #1 to Post #3.

I've added the Count of Suburb as a field in your pivot trying to answer Post #1.

You don't use a calculated field, just slide the Suburb field into the Values area of the pivot.

No not asking 2 thing. Just suppling as much info about what I am doing.

Ahh I see. man it makes sense now.. So I dragged Suburb into values and it worked..

Thank you sooooo much