How to show Percentage in Pivot Table?

Abs Hasan

New member
Joined
Aug 25, 2017
Messages
2
Reaction score
0
Points
0
Hi everyone, Is there anyone can help me to prepare a pivot table where i will be able to show percentage of attendance, Casual leave and Medical leave ?

I am always trying to prepare a table like "Number 1 picture", 1 table.PNGwhere Unplanned Leave will show percentage. But every time i ended up with "Number 2 Picture".2 table.PNG So is there anyone can help me with this problem? i also attached my excel file here. Thank you so much for your time.
 

Attachments

  • Copy of MIS Test (Aug16) - V2.xls
    38 KB · Views: 18
Back
Top