3 Replies Latest reply on Feb 1, 2017 5:50 AM by Stephen Rizzo

    Highlighting shortest expiry lot from inventory data

    Kunal Arun Sonawane

      I need to highlight the shortest expiry lot from the inventory data for each product. We have different physical locations (Business Unit) named - 2010/1000/1010/1020/1040.

      Ideally, the shortest expiry lot should be in 2010.

       

      My problem - If there is any lot for same product in any other location than 2010 with expiry shorter than 2010, then it needs to be highlighted. How to do that?

       

      (I have attached the inventory data excel and rough working in Tableau)