Sub summary effect in a trailing grand summary?
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.
Trailing Grand Summary:
DESIGNERS DESIGN TOTALS
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.