I am importing a large CSV file with latitude and longitude for 15000 suppliers in ArcGis Pro. I have a column denoting what type of supplier it is, Milk, Honey and Tea.....yes there are well above 15000 suppliers of these categpries
When converting the table to plot on my map (XY Points) I want each category to be selectable in the content view so I quickly can look at only Milk suppliers for example. I prefer not to split the table into subsets for each category as I want to do calculations on the whole dataset as well.
Set multiple definition queries on the same layer; one def query each for Milk, Honey, and Tea.
Then use the Definition Query dropdown to quickly switch between each query, or set back to <None> when you want to see/do calculations on the whole set.