Results 1 to 3 of 3

Thread: How to show Percentage in Pivot Table?

  1. #1

    How to show Percentage in Pivot Table?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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", Click image for larger version. 

Name:	1 table.PNG 
Views:	19 
Size:	13.3 KB 
ID:	7286where Unplanned Leave will show percentage. But every time i ended up with "Number 2 Picture".Click image for larger version. 

Name:	2 table.PNG 
Views:	19 
Size:	9.6 KB 
ID:	7287 So is there anyone can help me with this problem? i also attached my excel file here. Thank you so much for your time.
    Attached Files Attached Files

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,675
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi and welcome
    Is this some kind of homework?
    Thank you Ken for this secure forum.

  3. #3
    Yes, actually this is for my Job test Preparation...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •