3 Replies Latest reply on Dec 6, 2018 11:54 AM by Valerie Bank

    Filtering on two values of a field

    Valerie Bank

      Hi,

       

      I have a data set where each item is on multiple types of purchase orders  (domestic, direct, replenishment order, represented by the "international term code" columns), with each item being its own row. My question is is it possible to filter to show only items that have both FOB and UC1 POs? I tried a PREVIOUS_VALUE calculation but couldn't get it to work.