Filter on Dimension Field using input box

[vijayit43]

Show those employee which Amount is greater than given input box

[cfz]

Hi Vijay,

Please find attached an example.

I hope it helps.

Carlos

[bbi_mba_76]

Hi,

if you have a chart you could use an expression like if(sum(Amount)>v_InputBox, sum(Amount)) and use the suppress when value is null, or add it as calculated dimension.

[vijayit43]

Where is attached File???

[cfz]

Just below the text in the comment.

[MK_QSL]

Use below script..

====

Load * Inline

[

  Customer, Sales

  A, 100

  B, 120

  C, 200

  D, 150

  E, 160

];

====

Create a variable vTOTAL and keep it in Input Box

Create a straight table

Dimension

=IF(Aggr(SUM(Sales),Customer)>=$(vTOTAL), Customer)

Tick Suppress When Value is Null

Expression

SUM(Sales)

Now you can change the value of vTOTAL in input box and can see it's effect of Straight Table...