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
The user will input a number which will be stored in a variable. Lets call the variable vVar and then you will test your expression to see if its above or below it and based on what you want show the value:
If(yourExpression >= $(vVar), yourExpression)
Does this help? if this is not what you want, can you explain with an example?
If you want to see rates above user inputs, you can try this
If(YourExpression >= UserInput, YourExpression)
Adjust the above expression according to your need.
HTH
Best,
Sunny
Use this type of expression
if(SUM(Value) >= vTextBoxVariable, SUM(Value))
The main issue is i don't know how to filter with expression results in an input box. That was my question.
The user will input a number which will be stored in a variable. Lets call the variable vVar and then you will test your expression to see if its above or below it and based on what you want show the value:
If(yourExpression >= $(vVar), yourExpression)
Does this help? if this is not what you want, can you explain with an example?
Please find attached
I would try this:
=If(sum(stkqty)-sum(onorder)-sum(onpick) = $(vVar), sum(stkqty)-sum(onorder)-sum(onpick))
where vVar will equal 2 based on user input.
Wow your so helpful my friend!
That worked great.. One more thing when i use this expression when nothing is selected nothing shows up in table how can i change this?
Try this:
=If(Len(Trim($(vVar))) = 0, sum(stkqty)-sum(onorder)-sum(onpick), If(sum(stkqty)-sum(onorder)-sum(onpick) = $(vVar), sum(stkqty)-sum(onorder)-sum(onpick)))
mhmm i used this expression and it stopped working altogether.