6 Replies Latest reply on Jun 26, 2018 8:44 AM by Jim Dehner

    Filtering by OrderNo based on results from calculation

    Malvika Bodh

      Hello!

       

      I am trying to filter out all Order Numbers that have the term 'AP&C' in item description.  These Order Numbers are not unique (sample table below for illustration), but I want to remove all orders associated with the order numbers that have that term (remove 1, 2, 4). For solving this, I created a calculated field that gives the order no.s and 0's. I wanted to use this as a filter (using orderno) in my worksheet. The issue that I am facing is that I am not able to remove these OrderNo.'s as by applying all the other filters that are relevant to the calculation, the calculated field becomes useless as the source data for both the worksheets becomes disjoint. It would work if I were to export the OrderNo.'s and then import that sheet to filter out unwanted OrderNo.s. Is there any other way this could be done automatically (without the export-import step)?

       

       

       

      OrderNoItem Description
      1item AP&C
      2item
      2item AP&C
      2item
      3item
      4item
      4item AP&C
      4item
      4item
      4item

      1.JPG2.JPG