7 Replies Latest reply: Feb 23, 2013 7:27 PM by Rob Wunderlich RSS

    how to return a value based on 2 dimensions

    Jackie fung

      hello all

       

      not sure what the best way or even how to do this.

       

       

      PRICE

      Product

      Color

      Month

      100

      jeepblackjan
      150jeepblackfeb
      155jeepredjan
      100jeepredfeb
      100suvbluejan
      100suvredjan
      175suvbluefeb
      100suvredfeb

       

       

      how do i get the max price based on 2 dimensions above..  product and color? regardless of month, even though i have more than 2 years worth of data..

       

      i tried max and aggr but i keep getting calc errors.

       

      not sure whats best or how to go about it.

       

      thanks