3 Replies Latest reply on Jun 20, 2013 4:06 PM by philmodjunk

    Calculated result of the running total containing duplicates

    Jm_1

      Title

      Calculated result of the running total containing duplicates

      Post

           I have a set of records and just want to see a calculated end result of the running total.

           It consists of 2 fields and looks like this:
            

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
                          FIELD 1                     FIELD 2
                          A                     a
                          A                     a
                          A                     a
                          A                     b
                          A                     b
                          B                     a
                          B                     a
                          B                     b


           The output should only show:

           Aa 3x
           Ab 2x
           Ba 2x
           Bb 1x

           Must be pretty simple but I'm not shure how to get there.
           Any help is kindly appreciated.