• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

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.
 
Top