4 Replies Latest reply on Sep 9, 2009 12:18 PM by firth5

    Sub summary effect in a trailing grand summary?

    firth5

      Title

      Sub summary effect in a trailing grand summary?

      Post

      I would like to set up a report listing  A) unique text of a field, and B) total # of times that unique text appears.  However, I would like to do this in the trailing grand summary, not as a sub summary.

       

      Example:

       

      Body: 

       

      DESIGN   DESIGNER

      Truck       Aaron

      Car          Betty

      Bicycle     Aaron

      Train        Aaron

      Plane       Betty

       

       

      Trailing Grand Summary:

       

      DESIGNERS     DESIGN TOTALS

      Aaron             3

      Betty              2 

       

       

      Please give me a place to start.  I can't seem to find a function that looks at a field and determines if the value is unique or not.

      I know that I could write specific calculations that searches for pre-determined designer's names and counts them up.  However, the designer names may change often, and I don't want to have to write a new calculation with that specific name each time. 

       

      Thanks in advance.