5 Replies Latest reply on Jun 2, 2017 9:10 PM by tish.fernandes

    Exclude rows based on conditions

    tish.fernandes

      Hi,

       

      Condition 1: I want to identify products whose combined 'shipping mode' sales are less than $3000 – This excludes rows 1-9 and should only show Rows 10-21

       

      Condition 2: If shipping mode is exclusively ‘standard’ and no other, then despite its sales meeting condition 1, the product should be excluded – Rows 10,11,19,20

       

      I want to see the rows that satisfy both conditions = Rows 12,13,14,15,16,17,18,21

       

      Any help with the calcualtion for doing this?