I'm trying to build some searches based on the "Billing State" of US customers, but I'm finding that "Billing State" is available for Search Results, but NOT available for Search Criteria nor Search Filters.
This means I can make a search that shows me a list of all the US Customers and a results column with their associated Billing State, but I can't filter or reduce that list in anyway. The list is many, many thousand lines.
There are some Billing Address fields that ARE available for Criteria and Filters (Address, Address1, Address2, Address3, Address Label, Address Phone, Addressee, Attention, City, Country, Default Billing, Default Shipping, Internal ID, Internal ID (Number), & Zip) but, unfathomably, State is not among them.
Can somebody please explain why this is the case?
Or better yet, can somebody please illustrate how much of an idiot I am being by showing me the correct way to filter customers by State.
(I'm trying to do a Mass Update to reassign Territories by State, but Billing State does not seem to be usable for this purpose).