Filter Adhoc report using Number filter

[#1]

In Adhoc reporting, I have a situation where I have to filter the table based on a column.

That is I have to keep number filters >1, >0.01 and >0.005 in a List box.

Based on this selection, Adhoc report should filter based on column A.

Help me out in this. Thanks

[#2 · Accepted solution]

Hi Hareen,

Keep the number filters on a slider or as buttons and assign the selected value to a variable.

Solution 1:

Use this variable in your report to proceed with the filtering. You can achieve this from 'Properties -> Dimension Limit -> Limits -> Show only Values that are: -> Greater Than -> (variable value)'

Solution 2:

On your expressions use IF condition using the variable value to filter the values.

Hope this will help you.

Thanks,

Harika