Calculated Field % to show

[fareedexcel]

Hi Users,

I'm facing difficulty in getting the % for calculated field. Total 5 days are there. I need to see How many people are present on each days. So for example Sun 5 people came in Finance Department. The total headcount of finance is 10. So i need to see the % of present = 5/10 = 50%.

Please help how to achieve this using calculated field.

 

[rahulshewale1]

hi @fareedexcel ,

see if is ok ?

Power Pivot Solution.
Sun %:=DIVIDE([Sum of Sun],[Head Count])

 

[fareedexcel]

Thanks for the solution in Power Pivot. Is there any option to get the result in Pivot Tables. I tried using calculated fields. But getting error

 

[Chihiro]

You need helper column in source.
Ex: In A3="Helper"
A4:A7 = 1

Then change pivottable source to include Column A.

Add calculated field.
=Sun/Helper

Format field as Percentage.

In Calculated field, before any formula/calculations are applied, all underlying values are summed first.