Thank you so much for the prompt reply and sorry it has taken me so long to examine the result. I see that this works, but I'm confused as to how exactly. Specifically, I don't understand how the if statement for the calculated field gives us what we need:
if [Customer Name]=[Select Customer Name] then "show" else "Hide" END
Please briefly walk me through how this works. Thank you!