My current pivot table looks like this:
pivot table.png
I want the result to look like that but add the bottom subtotals like this one: (I cleaned it up a little because I had to manually enter)
pivot table 2.png
My current pivot table looks like this:
pivot table.png
I want the result to look like that but add the bottom subtotals like this one: (I cleaned it up a little because I had to manually enter)
pivot table 2.png
Hi -
It's hard to tell from the images you posted, but it looks like all you've done is hidden the dollar values? Can you just select the columns in your pivot table you don't want to show and hide them?
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
I am adding rows to it. The HOL, OT, REG, and TRAIN are codes and I want them to total per department. Departments are the Social Service, MDS Coordinator, Dietary Supervisor ect. All I can get the codes to to is total per employee. The Employee is the blacked out part in the first picture and they are Andrea, Ericka, Brenda in the other table or the codes will subtotal at the very bottom with the grand total. It is possible to have them subtotal per department?
This appears to just be a duplicate of this: http://www.excelforum.com/excel-char...ease-help.html
I have closed your other thread, so you can continue here...
http://www.excelforum.com/excel-char...ease-help.html
If that was not the same as this 1, please send me a PM and explain, so I can re-open that 1.
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you![]()
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
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
ye it was I am sorry. I don't know how to upload the file?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
This is how my pivot table is. I want under each department a subtotal of the Codes. Like that is at the bottom of the pivot table above grand total.
You can't do that I'm afraid.
wow... really... well does anyone know of a way to do it maybe without the pivot table? I can get the data to export like the data sheet but a client of ours wants it to be a comparison. If we can't get it in the format they want we will have to manually key everything. With new employees being added and different codes being added quite often I figured the pivot table would be the best way to go about it.
***The original data is much larger than this. I cut it down a lot just for example purposes.
Well, you might be able to do it with Power Pivot using some complicated measures, or you could do it with an Access report if it's for printing. Alternatively, coding it would be possible, but not something I personally have time for at the moment.
I have been researching power pivot I cannot figure out how to do it there. And access is not an option because I have it but other in the office don't.
Hi -
Does it all have to be in one pivot table? Why not have a separate pivot table that counts codes by department? Or sum hours by code by department?
Just throwing ideas out there.
loginjmor makes a very good point.
see the attached file (with his/her suggestion).
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.
Yes I really need it all in one spread sheet. Right now this payroll software can print pdf every pay period and the client wants this comparasion report to look just like the pdf report so As of right now we have to manually key this whole report. and If a new employee gets added we have to add them and same with a new code it is taking a very long time. So I was trying to eliminate the tedious keying. But if it can't look like the pdf its pointless. This client is very very picky...![]()
If it is not allowed to use 2 pivot tables (which you can post beneath each other), then I think it is not possible.
If it's an important client, I suggest you contract someone to write some code for you that will generate the layout you want.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks