Error filtering data in simple table

[Anonymous]

How are you,

I have a problem filtering records in a simple table, when I filter a field I get more records. see images.

Table:

Tabla Aggregate

Filter >80

Values less than 80 are displayed

Thanks

Juan Monasí

[vamsee]

whats your formula for total and what are your dimensions?

Can you provide a sample app?

[Anonymous]

Hi,

I attach the document

[vamsee]

Hi Juan,

I have looked at your data. Column F is being aggregated as Sum(F).

The search happening on your Total column for >80 selects its respective dimensions.

i.e. for Sum(F) > 80 in the straight table selects B -1,2 and C - F1, F2, F4.

Selections are always made on Dimensions, not on expressions.

I have added a Current Selections Object which shows you the selections made.

Alternatively, if your search has to be user based then create a list box or Multi box for column F.