Unique value from Pivot table.

[charlie71]

Hello all - Hope someone can help.

I've attached a PT I am stuck with. What I am trying to do is run a report to show the number of areas per incident number. ie. The first incident 21874757 appears twice - both stating Harlow Central.

I only want to count Harlow Central once in the results. Whereas with Incident 21874827, I'd want to count each of the areas individually.

Can someone point me in the right direction please?

Than you.

Charlie.