3 Replies Latest reply on Aug 11, 2016 1:52 PM by Aaron Lum

    Using LOOKUP() for strings

    Aaron Lum

      Is there any way to use the LOOKUP() function for previous strings? In  the attached workbook, when hovering over a sales bar, I'd like to see the names of all the customers.

       

      My initial idea would be to use the LOOKUP() function in a calculated field that looks up to as many fields back as we know there are customers from that state (i.e. we have 2 Wyoming customers, and we then use LOOKUP([Customer Name], -1) + LOOKUP([Customer Name], -2). I understand this may not be the most elegant solution because we don't know how many far back to go, but in the data set I have at work, there isn't much to go through and so just making it work would be fine.

       

      Can anyone comment on whether this might work or if there is a better workaround?