How to Calculate Percentages based on Different totals?

[ganga9211]

I need to Calculate Percentages of Male / Females based on certain criteria as listed below under each Lead, I tried  the following but it calculates the % considering the Grand total , I need a formula in Expression to calculate this percentage considering the Total of Male/Females under each Lead rather than the Grand total.

Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}distinct [UID])
/
(Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}distinct TOTAL [UID])-(Count({<[Employee ID] = {"-"}>}distinct TOTAL [UID])))

Lead	Gender	Count	% of Total	Need this Correct % of Total
A	Male	73	8%	68.22%
	Female	34	4%	31.78%
B	Male	9	1%	69.23%
	Female	4	0%	30.77%
C	Male	54	6%	79.41%
	Female	14	2%	20.59%
D	Male	106	12%	85.48%
	Female	18	2%	14.52%
E	Male	336	39%	82.56%
	Female	71	8%	17.44%
F	Male	40	5%	75.47%
	Female	13	1%	24.53%
G	Male	16	2%	100.00%
H	Male	20	2%	83.33%
	Female	4	0%	16.67%
I	Male	40	5%	72.73%
	Female	15	2%	27.27%
		867	100%

[sasikanth]

HI,

Include Lead dimension inside like below 

=(Count(distinct ID)/ Count( TOTAL <Lead> DISTINCT ID) ) *100

Your expression :

Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}distinct [UID])
/
(Count({1<[End Date] = {">=$(=Date(Today(), 'DD/MM/YYYY'))","-"}>}TOTAL <Lead>  distinct  [UID])-(Count({<[Employee ID] = {"-"}>} TOTAL <Lead>  distinct  [UID])))

Thanks, 

Sasi

[ganga9211]

Thank you Sasi, but it doesn't seem to be working.

[sasikanth]

Would you be able share some sample data??