4 Replies Latest reply on Jul 25, 2016 6:51 AM by paolo.raia

    LOD to find dimension value

    paolo.raia

      Good afternoon,

       

      I'm delving into the interesting world of LOD and require some advice regarding returning dimension results.

       

      For example, here is a simple list and I would use {FIXED[LOG NO] : MIN([DATE]} to return the earliest date for each LOG NO :-

      My question, here, is rather than return the earliest date, I'd like to return the GROUP associated to the earliest DATE for each LOG NO.  I know INCLUDE and EXCLUDE arguments can be used, but I don't know how to apply these and whether they would help in this scenario.

       

      Many thanks in advance.