# Calculated Field % to show

#### fareedexcel

##### Member
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.

#### Attachments

• 22.7 KB Views: 2

#### rahulshewale1

##### Active Member
hi @fareedexcel ,

see if is ok ?

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

#### Attachments

• 187.5 KB Views: 3

#### fareedexcel

##### Member
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

##### Excel Ninja
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.