Hi,
Am trying to create a pivot table in this excel sheet. But its not working. I want to know how may candidates that have applied have Bachelors degree, High School, Master's degree, etc. The count in each of Education Level.
Also the functional area if possible.
Many many thanks,
Asif
Last edited by asifamanulla; 02-04-2013 at 07:45 AM. Reason: Solved, Thank you
You have to add an header to column D, E and F.
See if the attached file is what you're up to.
Please reply your comments.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
See attached
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you very much.
Is there a way to get count based on Experience Level too?
For eg; 0 years Exp
1-2 years exp
3-4 years
5-6 years
7- 9 years
Above 10 years
Maybe like this (new pivot table)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks