Multiple level counts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

You folks are always so helpful, I'm hoping you can assist with this.

I'm creating a report with a couple of grouping levels to count transactions
and calculate percentage of the Area by district and dealer.

I successfully created the count by dealer in the Dealer footer, but I can't
figure out how to count the records in the District footer. Ultimately, I'll
need to count all records in the report footer and create a Percentage of
Area calculation for both the Dealer and District footers. I'm not sure how
to write the expression that will calculate each dealer/district's trasaction
total as a percentage of the total report count.

I appreciate any help you can provide.
 
Sorry, I don't know what happened, but I did not intentionly reply to your
question, but if I understand your question, then it should just be a matter
of using the Count function in the Disttrict footer like you do in the Dealer
footer.
 
Is your sorting and grouping Dealer first then district or the other way
around?
Are there any other groups defined?
 
If you are counting in the District footer, then a count of one would be
correct. To count the districts, do the count in the report footer.
 
Back
Top