Dear All,
Could anybody help out to know what is meant by Pivot table and how it has to be created. I know that this table helps to fetch employee's data, but if you have any samples of the same, please post it or send it to
From India, Madras
5Could anybody help out to know what is meant by Pivot table and how it has to be created. I know that this table helps to fetch employee's data, but if you have any samples of the same, please post it or send it to
From India, Madras
Good Day,
Pivot Table is used to Fetch the Data according to our use or format as which column we need we can easily sort out, (Example - if the employee working for 12 hours daily and the total days he work for 15 days, the the total will come in last column, so to see only empid and total hour work, we can easily see through Pivot Table)
Steps -
1, Select new sheet or existing,
2, Go to Insert Option
3, Select Pivot Table
4, Then the dialog box open with some formula's type just click on ok, then one pop open with our sheet field names, then you need to slect exact with column u need to sort out the date.
5, Click on check box for needed column, then ok..
Attached is the sample excel sheet for same.
thanks,
From Kuwait, Hawalli
Pivot Table is used to Fetch the Data according to our use or format as which column we need we can easily sort out, (Example - if the employee working for 12 hours daily and the total days he work for 15 days, the the total will come in last column, so to see only empid and total hour work, we can easily see through Pivot Table)
Steps -
1, Select new sheet or existing,
2, Go to Insert Option
3, Select Pivot Table
4, Then the dialog box open with some formula's type just click on ok, then one pop open with our sheet field names, then you need to slect exact with column u need to sort out the date.
5, Click on check box for needed column, then ok..
Attached is the sample excel sheet for same.
thanks,
From Kuwait, Hawalli
Hi Sayeed, Thanks for your post... i have one more clarification, is this table is used for entering employee data’s like DOB, GENDER, Designation etc??
From India, Madras
From India, Madras
Dear all, Attached pl. find a pdf file containing good information on pivot tables. Regds. Ranjit J. Pandya
From India, Ahmadabad
From India, Ahmadabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
PIVOT TABLE SAMPLE.zip
Pivot Table.pdf
Pivot table.doc