Filter Across Multiple Columns

[bsolove123]

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?

[Kenda · Accepted solution]

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

[nagakavyasri]

[hlee36]

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.