I have a report that sums mulitple events by division based upon a crosstabs query. The output is similar to the following:
Event 1 Div A total Div B total Total of Event 1...
Event 2 Div A total Div B total Total of Event 2...
Event 3 Div A total Div B total Total of Event 3...
_________________________________________________________
Div A total Div B total Total of all events
of all events of all events
The same report produces an overal sum of events by including the appropriate fields in the report header section, as indicated in the section below the line.
Here the question:
How do I create a calculated field that is [Total of Event 1]/[Total of all Events]? The output for each event should appear in the grouping for that event (i.e., the percentage for Event 1 should appear in the Event 1 section).
