14 Replies Latest reply on May 29, 2015 10:13 AM by kettan

    create lookup table

    Gijs van Kersen

      I have a big sales file with purchase order (PO) numbers and product descriptions.

      Now i need to show the revenue from all POs that INCLUDE a particular product.

      So I can't just filter on that product, as I need to also include all other products in that same PO.

       

      Can i create a table that contains all POs, and then do a lookup to that table (as I would in XLS)?

      How would i go about this?

       

      Thanx!

      Gijs.


      EDIT: I can't add the full workbook (too big and confidential) but i attach here a small sample that should make it clear.