I have a data table which looks something like this:
Ref Department Type
ENQ007740 Yellow Team AIR
ENQ007740 Yellow Team SEA
ENQ007745 Yellow Team SEA
ENQ007746 Red Team AIR
ENQ007748 Green Team AIR
ENQ007748 Green Team SEA
I want to count the number of enquiries by team.
So if I do this manually I would get:
Yellow 2
Red 1
Green 1
But if I use a pivot then I get:
Yellow 3
Red 1
Green 2
Because it can't recognise that some of the references are the same.
How can I get it to count discrete references only?
Thanks
Bookmarks