Input Box Filter Based on Expression

[#1]

Hey guys,

Quick question

I have a dashboard with a pivot table. The pivot table has many dimensions and one Expression.

The expression is shown in %. I need to create an Input box where a customer can enter a % and it will filter based on the % they inputed..

Any idea's?

Thanks allot

[sunny_talwar]

Can you try this:

=Alt(If(sum(stkqty)-sum(onorder)-sum(onpick) = $(vVar), sum(stkqty)-sum(onorder)-sum(onpick)), sum(stkqty)-sum(onorder)-sum(onpick))

[#3]

user must enter 0 for everything to show is there a way to make it so ENTER nothing automatically shows 0?

It works though so that's great, thank you very much

[sunny_talwar]

May be one of these two?

=If(sum(stkqty)-sum(onorder)-sum(onpick) = Alt($(vVar), 0), sum(stkqty)-sum(onorder)-sum(onpick)) or

=If(sum(stkqty)-sum(onorder)-sum(onpick) = If(Len(Trim($(vVar))) = 0, 0, $(vVar)), sum(stkqty)-sum(onorder)-sum(onpick))