Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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í
whats your formula for total and what are your dimensions?
Can you provide a sample app?
Hi,
I attach the document
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.