Group Percentage calculation on a higher group 1

[JEnright1]

I need to calculate a percentage count for each user within a group 'user' of the total count for a company that each user is within.

Group 3 is user
user 1 count 200 Percentage = 200 / 600 33.33%
user 2 count 400 Percentage = 400 / 600 66.66%


Group 2 is Company Total Count =600

Group 1 is all companies within a higher group

Thank You

 

[lbass]

Use a formula like the following in a group #3 header or footer section:

count({table.user},{table.user})%count({table.user},{table.company})

-LB

 

[JEnright1]

LB,

Thank You. I missed one additional thing. I want to get the percentage of a subset of the totals in each group
(Count of item count for user where item_type='X') :

Group 3 is user

user 1 TOTAL count 200 'X' Count 100
Percentage = 100/400 25%



Group 2 is Company
company TOTAL count =600 'X' Count = 400

Group 1 is all companies within a higher group

 

[lbass]

Create a formula {@X} like this:

if {table.field} = "X" then 1

Then use a formula like this (be sure to use SUM, not count):

sum({@X},{table.user}) % sum({@X},{table.company})

-LB

 

[JEnright1]

LB,

Thank You. Thank You. Thank You. EXCELLENT.