percentage require from gender count column

[yadav_anil782]

Hi team ,

i have one dimension column " gender" and one Count of gender which is calculated column,

in next column i need percentage of  male and female so how to calculate the value . plz suggest i attached excel sheet

[ashfaq_haseeb]

Hi,

Add 1 more expression to your pivot table.

Assuming your Count Expression is as follows

=Count(Gender)

Add another expression as below (Percentage)

=Count(Gender)/Count(Total Gender)

Now go to Number Tab select expression (Percentage) Change the number format setting to Number select 4 Precision and make sure to select show in % checkbox then click ok.

have a look at attached image.

hope it helps

Regards

ASHFAQ

[yadav_anil782]

Hi ,

gender is dimension field , i need to calculated emp count field 

[ashfaq_haseeb]

Hi,

Modify script accordingly

=Count(Emp)

Add another expression as below (Percentage)

=Count(Emp)/Count(Total Emp)