Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Try maybe
=aggr(if( Sum(Value) <=MaxVal and Sum(Value) >= MinVal,Qualification),Qualification,DIM)
Try maybe
=aggr(if( Sum(Value) <=MaxVal and Sum(Value) >= MinVal,Qualification),Qualification,DIM)
I tried with this option and works fine Thanks !!