Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following table:
| rid | eid |
|---|---|
| null | 1 |
| 2 | 2 |
| 3 | null |
| 4 | 4 |
| null | 5 |
I want the table to only show rows with values "1" and "5". In the filter pane, if "2" is chosen, the table should not display anything.
How can I implement this?
Thanks
i Suppose you are talking about 1 and 5 in eid,
Try this :
In you table select eid as Dimension
and as measure write Only({<eid={'1','5'}>}rid)
no, i want to filter this values out automaticaly, without expilicitly writing '1','5'? Is it possible?