Creating a threshold filter for a table

[Evan0211]

I have a table that has a field on it with dollar amounts.  I would like to create a threshold filter of pre-defined values (All, 100k, 500k, 1M, etc) and when the user selects the amount, the table will filter to the items that are >= the threshold.  I cannot find any charts or controls that will do this.  I do not have the ability to install any extensions due to restrictions from the data owner.

Thanks!

[jwjackso]

You can use the Variable Input with Set Analysis.

Create a variable, vFilter and in the Variable Input define it as 

='~All|{<[Dollar Amount]={">100000"}>}~>100k|{<[Dollar Amount]={">500000"}>}~>500k|{<[Dollar Amount]={">1000000"}>}~1M'

Your table expression would look like

Sum($(vFilter)[Dollar Amount])

[Evan0211]

It says Error in Expressions ')' expected

The plain text shows Sum(100000 [Dollar Amount])

[jwjackso]

Can you show the string that you used in the variable dynamic expression field?  Also replace the [Dollar Amount] with the real field name.

[Evan0211]

I upped the numbers to M from K.

Variable - 

='~All|{<[Total Value]={">1000000"}>}~>1M|{<[Total Value]={">5000000"}>}~>5M|{<[Total Value]={">10000000"}>}~10M'

Expression -

Sum($(vFilter)[Total Value])

[jwjackso]

With the following data:

Set vFilter="";

Data:
Load * Inline [
Dept,Total Value
D0,100000
D1,1000000
D2,5000000
D3,10000000
D4,20000000
];

Using your variable string:

The variable filter works

[Evan0211]

When I toggle through the buttons, the data does not limit and the column that holds the amounts all turn to "-"

[jwjackso]

In the expression editor for Sum($(vFilter)[Total Value]), at the bottom, how has the $(vFilter) been expanded

[Evan0211]

The expression in the column of the table is: =Sum($(vFilter)[Total Value])

The bottom shows: =Sum([TotalValue])

vFilter has not been expanded on the bottom.

[jwjackso]

And you have selected something other than the All button?