title: For each consumer find the cheapest product that was purchased
body: <p>I am trying to obtain a list of the cheapest product that was purchased for by each consumer from a cube. I tried the following cube query:</p>
  
  <pre><code>SELECT "Consumer Name","Product Name",MIN([Total Price]) AS "Total Purchase Price"
  FROM Transaction_Cube 
  WHERE "Consumer Name" IS NOT NULL
      AND "Consumer City" IS NOT NULL
      AND "Consumer State" IS NOT NULL       
      AND "Product Name" IS NOT NULL 
      AND "Product Category" IS NOT NULL
      AND "Product Line" IS NOT NULL
      AND "Product Packaging" IS NOT NULL
  GROUP BY "Consumer Name","Product Name"
  </code></pre>
  
  <p>But that is giving me the following results:</p>
  
  <p><a href="https://i.stack.imgur.com/bSHCA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bSHCA.png" alt="enter image description here"></a></p>
  
  <p>where I am getting the lowest purchased price of each consumer/product combination. But what I am trying to achieve is something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/RikrC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RikrC.png" alt="enter image description here"></a></p>
  
  <p>where I have for each consumer only the cheapest product that was purchased. Any ideas or suggestions on how to correct this query would be truly appreciated!</p>