1 of 1 people found this helpful
So there are a few ways to go about this...Probably the simplest is to create a calculated field for each gender %age. We can do this by embedding a row level filter into one side of each calculated field so it only counts the Males/Females, and then divide this by the the total...let me show you what I mean!
So for %age of Females the calculated field would be
COUNTD(IIF([Gender] = 'Female', [lid],NULL))/COUNTD([lid])
and for %age of Males the calculated field would be
COUNTD(IIF([Gender] = 'Male', [lid],NULL))/COUNTD([lid])
As countd doesn't (well can't!) count NULLs it only counts the Males/Females
You can then bring these 2 fields onto the Label tiles, and then arrange as required.
Hope this does the trick, and makes sense.
Thanks, This is exactly i was looking for.