I have two Account Lookups on the Deal object and want to filter a report based on the value in one of them, however that field does not show up in the field drop down when creating the filters. The other Account lookup that I do not need to filter DOES show up in that drop down. They both have the same permissions and properties.
Why would one show up and not the other?
Thanks in advance for your help!