Forum Discussion

tlene8's avatar
tlene8
Copper Contributor
Aug 10, 2023

Sorting a pivot table in specified order. Not alphabetically or numerically.

I do about 30 employee time cards every week, so the job #'s are constantly changing. We need this info to know how much to charge our customer per job that is done based off of the hours that our guy worked on that particular job. 

I need my pivot table (Column's H-J) to sort my job #'s (Column D) in a specified order. I tried using the custom list option but the issue that I am having is the job #'s change every time card that I do & every week. I have googled and search and nothing I have found seems to get me the results I am looking for. I'm pretty sure I am going to have to use a formula or coding for this, but I am stuck on how to go about doing this. 

I need my list in this order (reminder, that ALL numbers change, however the letters do not change):

1: 220000/230000 #'s - These are our road jobs and this is simply in numerical   order & next year we will start over with 240000.

2: Any job that starts with "SS", the issue I am having here is that "shop" which is further down the list, usually jumps to this spot.

3: Any job that starts with "R"

4: "F" #'s

5: "T" #'s

6: "FAB" #'s

7: "RC" #'s

8: SHOP/PARTS

9: HOLIDAY

10: SICK

11: VACATION

 

3 Replies

Resources