Ok so I added some more records to the sheet Jobcost so the "Job" number is out of order. This is how our database actually works. This sample data is supposed to represent our database. I have a pivot table on the tab named "PivotTable". I get 2 entries on the pivot table for job 100001. And the forum deleted my images I pasted in.
Do I have to sort the Job column on JobCost sheet before I do a pivot table?
I've attached an updated spreadsheet.
Thank you!
EDIT: Spreadsheet updated here.
|