This content has been marked as final. Show 2 replies
Hello QV Community,
I am making a pivot table that will show total email vs total mail. I have a field labeled FName which has the location name and type of communication so I need to search the whole text for just 'mail' or 'email', and I need to just show email and mail. When I use the below expression, the figures are correct and it shows the label Email, but not the label Mail (it shows a dash ' - ' ). How can I adjust this to show both Email and Mail?
PICK(WILDMATCH(TRIM(UPPER(FName)), '*EMAIL*') ,'Email','Mail')