When building pivot tables, Zoho automatically selects 'lookup paths' for you based on which columns are configured.
Sometimes, I want zoho to not use a look-up at all between two tables.... but that doesn't seem to be an option, as long as any relationships exist between two tables used in your report.
Is there a way to force zoho to not relate two tables, in a specific report?
In my attachment, you'll see an example of a relationship that I'd like to remove.