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.
Hi,
If you add the data to the data model when creating the pivot table, you will then have a distinct count option available to you.
Don
Please remember to mark your thread 'Solved' when appropriate.
Fabulous - Thanks xlnitwit - I didn't know about that at all - That's two queries you've helped me with in the last couple of months -
Much appreciated.
https://media2.giphy.com/media/8aYLkCDqldRbq/200w.webp
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks