1 Reply Latest reply on Sep 11, 2019 5:44 PM by swaroop.gantela

    Dynamic Grouping

    Akshata B

      Hi All.

      I need help on creating dynamic groups on a field called [Account Name]. It contains the names belonging to 2 different companies A and B. I want to group the names which are similar in both A and B companies


      Account Name       Type

      Blue.com                  A

      Blue.inc                    B

      Red                          B

      Red.com                  A

      GREEN                    A

      green                       B

      Yellow.inc                 B

      Brown                       A


      Since there are more than 200000 rows, I cant do it manually. Any help on calculation will be highly appreciated.

      Thanks in Advance