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


      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.