Hi all,
I have a slightly annoying problem that I can't seem to get my head around.
Unfortunately its NHS data so I can't upload but hopefully I can explain my issue.
I've created a population pyramid based on gender and age group. In my dataset I have 'Age Band' and 'Gender' so have created 2 calculations (IF Gender = 'Male' then -Headcount End) and similar for Female.
This works fine and I can add the Headcount figure in with no issues.
However what I'd like to do is add the % for each of the segments that I've created.
I can't use a quick calculation as I now have 2 measure and I've tried using Female Headcount / Fixed Headcount but that doesn't seem to work either.
Happy to fabricate a Pyramid and upload if that would help.
I can't help but feel I'm missing something really obvious here but would appreciate any assistance.
Thanks
Dave
