I have a worksheet with the following columns:
DEPTID, POSITION, PROGRAM, VENDOR Name, and Grand Total
From this data, I want to create a pivot table, with DEPTID, POSITION, VENDOR Name and Grand Total for my fields. I can do that just fine, but I want my DEPTIDs to be in Ascending Order, and within each Dept ID I want my Grand Totals in Ascending order. How do I do that?
I appreciate any help.
Last edited by jomili; 01-27-2012 at 02:27 PM.
Hi jomili,
I think you need to group the row data and then sort within the group. See if http://www.excelforum.com/excel-gene...-in-excel.html doesn't help. I think I gave an example on it. If not then supply a sample workbook and we'll see if we can make it do what you want.
One test is worth a thousand opinions.
Click the * below to say thanks.
Hi,
if you click twice on the grey label of right-most row field (maybe DEPT ID), you can open the pivot table window: click on Advanced then- in the new window -select Autosort option- Ascending -using field "Grand total".
I hope this is useful.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon below the post.
Please, mark your thread [SOLVED] if you received your answer.
Forum rules: http://www.excelforum.com/forum-rule...rum-rules.html
Marvin,
I didn't find anything in the link that would help with me present situation. See the attached workbook to see if this makes my problem any more clear. I'm open to either a manual method within the PT setup, or a VBA solution.
Canapone,
See the attached workbook. I tried your solution, but couldn't get it to work. If I sort by Grand Total, I lose my sort by DeptID. I need both.
Hi, I've set ascending order by clicking -also- on "Position" label in M3.
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon below the post.
Please, mark your thread [SOLVED] if you received your answer.
Forum rules: http://www.excelforum.com/forum-rule...rum-rules.html
A-ha! I knew there had to be a way! Thank you so much for point it out.
Hi,
forgot the subtotals in the pivot table.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon below the post.
Please, mark your thread [SOLVED] if you received your answer.
Forum rules: http://www.excelforum.com/forum-rule...rum-rules.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks