6. Select Accounts filtered on country, revenue and number of employees

note the scenario below uses data from the deselect demo data package see docid 5 cozdtg0nwmlmeufrmbz scenario you want to get the accounts that are from belgium and have more than 40 employees or from canada and have less than or equal to 20 million in revenue https //www youtube com/watch?v=qdoryylv5ok\&list=plfs7 dts7jwyhwe scy5z4qvgbh2ilspj\&index=6 or follow the steps below 1\ input on the selections overview screen, click on new to create a new selection drag data extension deselect demo accounts to the selected data extensions section drag field country to the selected filters section criteria equals value belgium drag field number of employees to the selected filters section criteria greater than or equal to value 40 drag field country to the selected filters section criteria equals value canada drag field revenue to the selected filters section criteria smaller than or equal to value 20000000 set the filter logic of the main level to or click the + icon on the country = belgium filter this will group the first 2 filters for country and number of employees set the filter logic of this grouping to and click on the + icon on the country = canada filter this will group country and revenue set the logic of this grouping to and 2\ output hit the create data extension button, enter a name, eg filtered accounts, and press save select the following fields by either double clicking on them or dragging them to the section on the right company name, country, number of employees and revenue from deselect demo accounts click save data extension 3\ preview when you click run preview on the preview screen, a results table will be shown with fields company name, country, number of employees, and revenue the results table shows only accounts from belgium that have more than 40 employees or are from canada and have less than 20 million in revenue