Thank you for the response, however, this is not what I am looking for. The first example yields the smallest two values in each state, which I do not want. It's a bit hard to explain, I will try to clarify better:
1. If any County has ALL of their stores with negative revenue, I want to know which store has the LEAST negative revenue. I do not want to see any counties that have stores with both positive and negative revenue in this view.
2. If any County has stores with both positive and negative views, show the stores with the least negative and most positive revenue in those counties.
Hopefully this helps clarify. Also, if you could help explain your formulas I would greatly appreciate it. I get confused with how to translate the syntax sometimes and am still learning. I can see what your filters yield and know that it isn't what I want, but I can't fully wrap my head around how that interacts with the data to present that view.
Thank you so much for the assistance.
I dont think you have all Negative in any County