I have a dataset which consists of 3 columns: Name, Number, Category. I want to summarize to see if any value in the Name category has any amount greater than 1000.
So if we have 3 customers and 1 customer has at least 1 row with a value greater than 1000, omit in the summarize. As you can see with the attached picture, "test" has values greater than 1000 and I'd like to summarize a table to not include "test". Any help or leads would be appreciated!