How to allow data select in chart bar based on y axes

[shahafei2]

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  

[Mark_Little]

Hi.

Create a variable vNUM.

Update your Set analysis to something like,

IF(SUM(sales)>=$(vNUM),SUM(Sales))

Mark

[shahafei2]

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)