Calculate average of each group

[gk17]

Hi,

I have the following groups:
Site
Dept
Resource

Details section: acct #

How do I display the percentage for each "resouce group" based on the number of acct # in each resource compared with the total of the other remaining resources? So as a very basic example, if we have the following resources and acct #s:

resource1
123
456
789

resource2
000
111
222
333
444
555

resource1 will have a count of 3 while resource2 will be 6. For resource1, the percentage should be 33% (3 from resource1 and 6 from resource2) while resource2 percentage should be 67%.

Thanks.

 

[briangriffin]

When you insert the Summary field (count of resourceID) into the group footer, you'll see in the dialog the option to show as a percentage of: In your case you would select Grand Total: Count of ResourceID).

This is easy with one group, but gets trickier when you have multiple groups. Just keep in mind what you want your numerator and denominator to represent when calculating the percentage.