I have a list of sorted data in a sub summary list view that looks something like this:

Apples

Apples

Apples

-----------------------------

Nuts

----------------------------

Pears

Pears

---------------------------

Bolts

---------------------------

I can get the sub-summary of each group ok however I need to do a calculation in a Trailing Grand Summary part based on a (set value x the number of data groups) (4) in above example. I can't seem to find the solution for counting the data groups Can someone suggest some options to do this?

Thanks

ValueCount ( UniqueValues ( listOfSummaryFieldHere ) )

Use a list of summary field to list the same field you show as Apples, Nuts, Pears... in your example