1 Reply Latest reply on Mar 25, 2013 3:32 PM by Dan Huff

    Displaying only rows that contain lowest value

    brunovais0

      Hi,

      I have a workbook (attached) that displays prices and sellers for products. How can I display only the lowest prices?

       

      tnx

        • 1. Re: Displaying only rows that contain lowest value
          Dan Huff

          Hello--

           

          First of all, welcome to the forums.

           

          Second, I have attached a workbook with two options. The first option simply removes Seller from the view and changed the aggregation of Price to Min. This gives us the minimum price within each SKU. The second option keeps Seller in the view and uses a filter-- sum(Price)=window_min(sum(Price)) -- to only show the Sellers within each SKU that have a price that matches the minimum within each SKU. This is accomplished by putting the Filter field onto the Level of Detail, right clicking it, hovering over compute using, and then selecting Pane Down (this forces it to restart for each SKU so that we see the minimum for each). Finally you just need to put this onto the filter shelf and keep the True value.

           

          Hope this helps,

           

          Dan