Adding a filter pane for a calculated field

[Selis]

Hi,

I have a table with several columns. One of them is a calculated column. Now I want to add a filter pane  which allows the user to filter this column (e.g - to choose all the numbers above or below a specific amount).

Is it possible (since I know that filter pane accepts only dimensions.) ?

Thanks. 

[sk88024]

you can make a master item (dimension) using the expression of that calculated column. And then use the same master item in the filter pane. 

[Selis]

Hi,

I've tried it but it doesn't work.

Thanks. 

[sk88024]

Not sure what your data looks like, so I have just created an example based on your question:

Load * Inline [
Number, Amount
1, 20
2, 30
3, 40
4, 50
5, 60
6, 200
7,90
8,100
];

Create a master item (dimension) using the calculated expression with field "Number" from Inline Load table:

Now, use the same master item in the Filter pane:

Hope this helps!!