Robert_L_Ross wrote...
You are obviously not wanting to listen to what I'm trying to say, so I'm not
going to continue to clog the thread up arguing with you.
....

Translation: you found out there's no direct way to count DISTINCT
text values from a text field using a pivot table, so rather than
admit you've been wrong in your last few follow-ups you'll feign a
high minded disappointment.