4 Replies Latest reply on Jun 15, 2018 9:48 AM by Hari Ankem

    Same UPC # and different name

    Martin Roitman

      Hi,

      I have a list of item names with UPC #. The name of the items can change time to time, however, the UPC does not.

      When I try to make a table using the name, I have multiples lines of the same UPC with different name, for example:

       

      UPC               Name                     $

      1                        aa                         3

      1                        ab                         4

      2                        ba                         6

      2                         bb                         7

      3                         ca                         5

       

      Even if I invert the columns I can not get the total. I can only get the total when I remove the name. The problem is that I need the name.

       

      UPC and Name are "STRINGS" I can change UPC to Integer. I try it but didn't have any effect.

       

      Please let me know if there is an easy solution for this.

       

      Thanks.