Result of expression between range

[#1]

I have a table without  relation or key with associative model, this table has the ranges (minimum value,maximum value and qualification) and the rating on the other hand I have an expression and result of this, should be classed with this table ranges.

This is the rante island table

MinVal	MaxVal	Qualification
0	10	1
11	20	2
21	30	3
31	100	4

And this is the pivot table desired

DIM	Sum(Value)	Qualification
A	8	1
B	15	2
C	23	3
D	50	4

How should i do this?

Thanks...

[swuehl · Accepted solution]

Try maybe

=aggr(if( Sum(Value) <=MaxVal and Sum(Value) >= MinVal,Qualification),Qualification,DIM)

[#3]

I tried with this option and works fine Thanks !!