Find the lowest value of selected

[#1]

Hi,

I have one list box with payment months (structure is YYYYMM), and then I have a bar chart diagram (SalesTable) showing the sales for the last 13 months.

What I want to set up is as below

1. I want to find the lowest payment month of the selected months in the list box

2. If the lowest month is >= the last 13 months the SalesTable should only show the selected months

3. If the lowest month is < the last 13 months the SalesTable should only show a error message

4. If no months is selected in the list box the SalesTable should show the default 13 last months sales

Is this something that is possible to do?

Thanks ahead!

[CELAMBARASAN]

Hi,

     For lowest payment in the selected month

     =$(=Min(Aggr(Sum(Sales),paymentMonth)))

     Use this in comparison of the 13 months expr but use that in $(=)

 =if(GetSelectedCount(MonthField)=0,13MonthExpression,if($(=Min(Aggr(Sum(Sales),paymentMonth)))>=$(=13monthexpression),Sum(Sales)))

For Error message Go to chart Properties-->General tab-->Calculation condition as below

if(GetSelectedCount(MonthField)>0 AND $(=Min(Aggr(Sum(Sales),paymentMonth)))<$(=13monthexpression),1,0)

Hope it helps

Celambarasan