9 Replies Latest reply on Jun 23, 2016 7:32 AM by Rohan Malusare

# Creating a Population Pyramid by Career Band and Gender

Hi Everyone,

I'm trying to create a population pyramid split by career band and gender. I want it to basically look like this, but with career band instead of age:

Below is an image of how far I can get (unfortunately I can't share the workbook as it contains confidential info). Pernr = the unique identifier.

I read the walk through above, which I think will help, but my first hurdle is that I can't quite figure out how to convert my gender dimension (currently a string) to a number, so that male = 1 and female = 2.

Any help would be much appreciated.

Many thanks,

• ###### 1. Re: Creating a Population Pyramid by Career Band and Gender

is it possible to share data with dummy value or workbook?

-Ashish

• ###### 3. Re: Creating a Population Pyramid by Career Band and Gender

Is this what you are looking for?

Refer below screenshot.

Thanks and regards,

Rohan Malusare.

2 of 2 people found this helpful
• ###### 4. Re: Creating a Population Pyramid by Career Band and Gender

Yes perfect! How did you do it?

• ###### 5. Re: Creating a Population Pyramid by Career Band and Gender

I have used below calculations. please refer to them. Put them in columns.

Calc_FemalePernr

IF  [Gender]="Female" THEN -([Pernr])

END

Calc_MalePernr

IF  [Gender]="Male" THEN ([Pernr])

END

Thanks Ashish Chaudhari for help.

Thanks and regards,

Rohan Malusare.

2 of 2 people found this helpful
• ###### 6. Re: Creating a Population Pyramid by Career Band and Gender

Single calculation required

if [Gender] = 'Male' then -1 else 1 end

now use this calculation as a sum for the visualisation

1 of 1 people found this helpful

• ###### 8. Re: Creating a Population Pyramid by Career Band and Gender

Another great solution, thank you!

• ###### 9. Re: Creating a Population Pyramid by Career Band and Gender

Mark the correct answer and closed the thread so people can refer if they have same issues.

Thanks and regards,

Rohan Malusare.