1 Reply Latest reply on Mar 25, 2015 1:33 PM by Dean Knickerbocker

    Looking Up a Dimension Value

    Dean Knickerbocker

      I have a pretty simple question that I am sure has an easy answer and I am simply trying too hard to figure it out.


      Lets say I have a measure Price.  And I want to display the minimum Price.  That is easy enough.  But if I also want to display a corresponding dimension, say Company Name, how do I go about that?  The actual example is a bit more complicated with groupings by other dimensions such as Region.


      So my approach was the get the index of the lowest price such as:


      Min Index = if  min([Price]) = window_min(min([Price]), first(), last()) then Index() end


      Then use this value, the Index into the table where the lowest price is found to get the company name.


      Lookup(ATTR([Company]),[Min Index])


      I have included a very basic sample.  Thanks for help anyone can provide.