AnsweredAssumed Answered

Sub summary effect in a trailing grand summary?

Question asked by firth5 on Sep 8, 2009
Latest reply on Sep 9, 2009 by 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. 

Outcomes