Attached is an example of my dataset. I want to filter on records where the values of all the companies data, by state and by category, are equal. The last column is what I would expect to be the output of the filter. Is there a way to do this?
Hi @bsolove123
If there are too many company names to include in a filter, you could consider using the Transpose tool to transform your data first, grouping by state and category. From there, use a Summarize tool to again group by these two fields and count the distinct values in the Value field. Lastly, use a Filter to keep just the records where the unique count is 1
You can use "filter" tool and make a formula.
In the formula, use "AND" operator to make multiple conditions.
So, this can be done with a single tool.
