Hi @JoanZ, You should add another column to SYS06 with the Representative( list P2), so you can compare if P2 is equal to Representative. IF 'P2 Product Brand' = Representative THEN TRUE ELSE FALSE. This is would be for your line item: First Occurrence of Representative Brand Family. Representative Brand Family line item should use IF First Occurrence of Representative Brand Family THEN 'P1 Product Brand Family' ELSE BLANK.
... View more
