Knowing exactly which field puts what data where has always been an issue for me

Hello Matthew,
Hope you enjoyed your Excel training this week.

Regarding placing the fields in a Pivot Table, read through the following to get an idea of how it works.

From the PivotTable Field List window, drag the fields with data that you want to display in rows to the drop area labeled Drop Row Fields Here.
If you don't see the field list, click within the outlines of the PivotTable drop areas, and make sure Show Field List is pressed in on the toolbar.

To see what levels of detail are available in fields that have levels, the click the + next to the field.

Drag fields with data that you want to display across columns to the drop area labeled Drop Column Fields Here.
Drag fields that contain the data that you want to summarize to the area labeled Drop Data Items Here.

If you add more than one data field, arrange these fields in the order you want: Right-click a data field, point to Order on the shortcut menu, and use the commands on the Order menu to move the field.

Drag fields that you want to use as page fields to the area labeled Drop Page Fields Here.
To rearrange fields, drag them from one area to another. To remove a field, drag it out of the PivotTable report.
To hide the drop area outlines, click a cell outside the PivotTable report.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft APPLICATION question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer