AnsweredAssumed Answered

Calculated result of the running total containing duplicates

Question asked by Jm_1 on Jun 20, 2013
Latest reply on Jun 20, 2013 by philmodjunk

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.

      

Outcomes