Matthew has attended:
Excel Intermediate course
Pivot Tables
The issue I have with pivot tables is that it is difficult knowing what data goes where
RE: Pivot Tables
Hi Matthew
Thank you for your question, and apologies for the delay in response.
The whole idea of the pivot table is that it gives you numerous choices in how you choose to display your data. Really there are no 'rules' on where items go in the pivot table area, apart from numerical values should go into the data items area.
I hope this helps.
Amanda