1 2 Previous Next 16 Replies Latest reply on May 21, 2018 10:32 AM by Jose Salazar

    How can one choose to include or exclude data with certain condition on a calculated field?

    Jose Salazar

      I have data with the following nature:

      Product
      Storage Location
      Quantity
      VineA1
      VineB3
      VineOther4
      CheeseC2
      CheeseOther1
      BreadA4
      BreadD1
      BreadOther5

       

      And a want calculate the total quantity of each product, and choose with a parameter, to include or exclude the storage location "Other".

       

      I should obtain, including "other":

      Product
      Total Quantity
      Bread10
      Cheese3
      Vine8

       

      and excluding "other"

      Product
      Total Quantity
      Bread5
      Cheese2
      Vine4

       

       

      any thoughts?

        1 2 Previous Next