Set Analysis in table not working

[jalanhart]

Hello, 

I am wondering about reasons why a set analysis would not work in a table when I add a field as a dimension. 

For example I made a table with just one field as a dimension. this is a list of site locations. I only want to show one site location in the table.

So i used this expression ={<SITE = {'85'} >}SITE and it doesn't filter anything down.

What could be the causes of this not filtering correctly?

[MatheusC · Accepted solution]

It was a little confusing, you are using the filter in one dimension?

If this is the case, see as follows with the Only function. The Only expression will return only one possible value according to its aggregation field.

In the expression, if its value is a string, you can keep the quotation marks, if it is a number value, you do not need the quotation marks:

Aggr(only({<SITE={'85'}>}SITE), SITE)

- Regards, Matheus