Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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
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))