I'm having trouble figuring out how to report Overtime in a pivot table. Apparently this is more difficult than it seems as I have had no reply on the Ozgrid forum or the Chandoo forum. Please take a look at the cross posting at
http://www.ozgrid.com/forum/showthread.php?t=148038
I have a sample file there and would really, really, really appreciate anyones help.
Thanks for taking a look!
Last edited by reillc01; 11-30-2010 at 05:22 PM.
FYI, you have to be a member at OzGrid to see the sample workbook.
Please post it here, if you want someone to look at it here.
Thanks.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi,
Happy to have a look but I'm not an OzGrid member so can you load your sample to this thread as well.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thanks a bunch. I got fussed at for errant cross posting etiquette, so I want to make sure to follow all the rules.
Attached is the sample file.
Thanks again.
See if the attached works for you.
I added 2 columns in Payroll that separate out the total cumulative regular hours from the overtime and then pivotted those in Sheet5
Thanks a bunch! So simple in retrospect. Didn't think of the AND argument for the sumifs function. That's why I went to sumproduct.
This almost solved a problem I have as well. What if on the payroll sheet, the Employees are not in order?
I have a similar workbook where I am entering employee hours and need to calculate total OT for a week and Pivot it. I'm not able to sort by employee though.
So the OT column will show the same OT for the week on each row that that employee is listed, instead of just once, which is making it difficult for me to extract the OT for multiple weeks in pivot table.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Any chance you wouldnt mind helping me as well with the same formula for my pivot table. I am having some trouble getting it
Administrative Note:Originally Posted by Franklin123
Any chance you wouldnt mind helping me as well with the same formula for my pivot table. I am having some trouble getting it
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks