Calculations in groups

rbuser

I am using groups to display the dataset produced by a query. There are 3
levels of grouping.

Each detail line shows a count for that record. I need to be able to show
that figure as a percentage of the total for that particular group.

I have tried DBCalc's and I have tried Variables that are only calculated on
second pass, but not getting anywhere.

I'm sure there must be a simple solution. Can anyone help?

Will Dutson

digitalmetaphors

See this sample demo for an example of how to do this:

http://www.digital-metaphors.com/tips/PercentageOfGroupTotal.zip

--
Cheers,

Alexander Kramnik
Digital Metaphors