Hello, I'm working on a master time sheet in the form of a pivot table that will populate it fields with pre-existing time sheet tables from multiple employees. I'm quite new to pivot table's, but I'v spent a few hours now trying to find a format style I like to display weekly and monthly time totals but I cant arrange my columns correctly... can someone explain what I need to do?
Here is a screen shot of a sample employee time sheet: http://i.imgur.com/lRQwU.jpg
To simplify what I am asking for:
- Want to know how to format a pivot table to this style.
- Want to be able to display data filtered by employee name.
- Want to be able to view weekly and monthly totals of time allocated to a certain activities.
Thank you!
Here is a screen shot of a sample employee time sheet: http://i.imgur.com/lRQwU.jpg
To simplify what I am asking for:
- Want to know how to format a pivot table to this style.
- Want to be able to display data filtered by employee name.
- Want to be able to view weekly and monthly totals of time allocated to a certain activities.
Thank you!
