set question ?

[Anonymous]

Hi Folks I have table like this

MINValue	MAXValue	Identifier
0	0.012	0
0.012	0.0347	1
0.0347	0.1096	2
0.1096	0.3034	3
0.3034	0.6301	4
0.6301	1.5115	5
1.5115	3.4873	6
3.4873	12.9616	7
12.9616	101	8

t2:

value	Monthnames
0	Jan-16
0.01	Feb-16
0.05	Mar-16
0.1	Apr-16
0.1	May-16
0.75	Jun-16
0.2	Jul-16
10	Aug-16
10.5	Sep-16
5.5	Nov-16
50	Dec-15
50.5	Nov-15
3.7	Oct-15
0.013	Mar-15
0.01094	Feb-15
1	Jan-15

in my chart dimension is month names and expression is

like

if (sum(value)>minvalue and sum(value)<maxvalue,,1,0)

here I don't have any association between the 2 tables

[settu_periasamy]

May be try like this..

if(value>=0 and value <=Min(maxvalue)  ,'a',

if(value>=Min(minvalue,2) and value <=Min(maxvalue,2)  ,'b',

if(value>=Min(minvalue,3) and value <=Min(maxvalue,3) ,'c',

if(value>=Min(minvalue,4) and value <=Min(maxvalue,4)  ,'d',

))))