This is the answer to my question just in case anyone else is having this isssue.
This was the query & regex I created to solve this issue:
|index=foo | stats dedupsplitvals=t latest(FieldNameOne) AS version By host, FieldNameTwo
| regex FieldNameTwoHere="Candy(\s|™)"
Explanation of process & solution:
I had to remove the Pivot Table and work directly with the data from the index. The PT severely limited what I could do with the data because I could not add anything before the table. By exploring the data I realized that I had to completely remove it from the query. I then created a regular expression to define what I was looking for. Splunks regex's are based on perl. I found this document to be incredibly helpful. https://perldoc.perl.org/perlre.pdf
To customize my regex I had to know the different variations the word would have so that I could only grab what I needed.
I performed a DC on FieldNameTwo to achieve this purpose. It looked like this:
|index=foo | stats dedupsplitvals=t latest(FieldNameOne) AS version By host, FieldNameTwoHere | stats dc(FieldNameTwoHere) as DistinctNameCount by FieldName_Two