Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I Have number of bar chart objects in container object
i would like to create a variable for input box that will allow the user to pick what Y value will be the maximum
and by setting this field the model will hide the irrelevant dates (x axes)
For example the first table summarize the sales per day for one of the sites
i would like that the user will be able to input 100,000 to the input box
and that the model will auto select/filter the dates with the sum(sales) below 100,000
Hi.
Create a variable vNUM.
Update your Set analysis to something like,
IF(SUM(sales)>=$(vNUM),SUM(Sales))
Mark
It's doesn't work i set a var (vMaxSales)
but when i tried to write the set analysis in the expression i received an error in the expression
This is the expression that i'm trying to use
Sum({$<sum(Sales)=-{'$(vMaxSales)'}>}Sales)