Multiple level counts

[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.

 

[Guest]

That is correct.

 

[Guest]

I'm sorry - I don't understand.

That is correct.

 

[Guest]

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.

 

[Guest]

I tried that, but it just comes up with a count of 1 for each district.

 

[Guest]

Is your sorting and grouping Dealer first then district or the other way
around?
Are there any other groups defined?

 

[Guest]

Grouping goes District first, then Dealer. There are no other groups defined.

 

[Guest]

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.