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.