How to return all clients with variance greater than some value? variable related question

[#1]

Hey

Newbie here.

I'm trying to compare budget vs actual by creating a simple bar chart. I also wanted to add an input box to allow some user interaction...

For example,user can type in 10% and it will return all clients with variance greater than 10%.

Please see attachment.

Thanks in advance.

Dorothy

[#2]

Sorry, accidentally clicked on the status..

Still need help...

[MK_QSL]

Instead of client use, calculated dimension and tick suppress when value is null

=IF(Aggr((Charged-Budget)/Budget,Client)>vPer,Client)

Expression is OK same as your have used...