function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Brent ABrent A 

OR statement syntax in Excel Connector filter row

Hello everybody -

 

I'm trying to query fields that have any of the 4 revenue types that we track greater than $249999.  When I build the query with the wizard it defaults to AND, so I'm not getting rows that have just one of the 4 revenue fields meeting the criteria.  Currently I've built 4 different queries to get this, but then when I pivot I get duplicates, etc and it's just not a clean report.  How do I adjust row 1 in the query spreadsheet to reflect the OR function? 

 

Thanks for being such a resourceful forum!  Have a great day.

 

Brent A