5 Replies Latest reply on Jun 29, 2018 5:41 AM by Jim Dehner

# Calculate percentage of M and F from Gender in diamension

Good day,

I felt this was an easy calculation but I and still struggling with it.

Problem is that I want only the percentage of F to remain when I filter out the M

But when ever I do that I get 100% for F.

I just want to see 33.33% for F and 66.67 % for M based on the filter selected.

Thanks

• ###### 1. Re: Calculate percentage of M and F from Gender in diamension

Hi Lawrence

Here it Is

Thanks

Deepak

• ###### 2. Re: Calculate percentage of M and F from Gender in diamension

Ah ..Here is attachment

• ###### 3. Re: Calculate percentage of M and F from Gender in diamension

see the attached

the count by gender is

the percent is

and you get this for female

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 4. Re: Calculate percentage of M and F from Gender in diamension

Thanks a lot for your help

It worked perfectly.

Have a great day.

• ###### 5. Re: Calculate percentage of M and F from Gender in diamension

Thanks

Have a good weekend

Jim