AnsweredAssumed Answered

Sub Summaries for Gender

Question asked by Woodzie on May 14, 2010
Latest reply on May 18, 2010 by Woodzie

Title

Sub Summaries for Gender

Post

 

I have run into a difficulty in reporting the number of police officers by gender on each peacekeeping mission. I'm working with three related tables Personnel Records (holds gender info) , a Missions Table (holds mission info) and Experience (join table holding relative experience info)

 

I cannot seem to be able to count officers listed as female / male in sub summaries.

 

Ideally, the report will  look like this

 

AMISOM                **This is my first sub summary by Mission Acronym** No problem.

Male: 1                  **This is my second summary by male. I've tried several pieces of code for doing this...none have worked latest is

Female: 3  <<male>> <count of people>>** -- male code is ValueCount ( FilterValues ( List ( Gender ) ; "Male" ) )

Total: 4

 

UNAMID

Male: 4

Female: 3

Total: 7

 

Grand Total: 11

 

I know I'm  missing something but I can't figure it out...probably simple as I haven't located the solution on the forums. Thanks in advance for the help

 

w.

 

 

Outcomes