7 Replies Latest reply on Jul 15, 2018 11:01 PM by m ovess

    Maximum and minimum price for a day in a city

    m ovess

      Hi,

      i have date dimension, seller  and city while single measure price.

      i have a date filter and city.

       

      Date                city               seller  price

      01-01-2012     London         A         25

      01-01-2012     London         B         14

      01-01-2012     London          C        19

      02-01-2012     New York       AA        18

      02-01-2012     London          B         17

      02-01-2012     London          C        21

       

      Suppose i want to show  which seller has maximum/Mininum price for the date  01-01-2012 and city=London

       

      Can anyone help.

       

      Thanks.