filter on a calculated field 1

[sharkatek]

I have a field I have constructed using three text values

It is a Row-Shelf-Bin combination. I am COUNTING the number of unique combinations for one location. How can I filter on the counts that are > 1?

Every time I go to the FILTER tab, my calculated field is not even there as a Report Column. How do I make it show up there so I can filter on it?

Thanks!
Sharkatek

 

[GJParker]

which application ar eyou using ?

If it's Impromptu you are using then on the filter tab change the Filter Type from Detail to Summary.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[sharkatek]

Thank-you! Such a SIMPLE thing but it will save me so much time in the future!

Sharkatek