Show only where distinct count = 1

[RGascoigne]

Hi,

I'm trying to show where a location has only a single item.  I have a list showing distinct count of items by location, however I only want to see when the distinct count is 1. 

Any ideas?

Rob

[hespora]

filter on the count and set filter to *after* auto aggregation.

possibly might not work; if so, then create a query reference instead.

[RGascoigne]

filter on the count and set filter to *after* auto aggregation worked fine.

Thanks for your help  :)

[hespora]

sure thing; glad I could help.