2 Replies Latest reply: Aug 9, 2012 8:32 AM by Marcos Herrera RSS

    Result of expression between range

      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

       

      MinValMaxValQualification
      0101
      11202
      21303
      311004

       

      And this is the pivot table desired

       

      DIMSum(Value)Qualification
      A81
      B152
      C233
      D504

       

      How should i do this?

       

      Thanks...