Hi,
I am a pivot chart amateur, so bear with me.
Basically I have a table where one employee will enter data. I then want to use a Pivot to summarise the data, and provide each of our drivers with a summary of their data. I want to be able to generate these summaries, filtering by Driver and Date.
However, I just cant get the pivot to pick up all the right columns, This is what it keeps doing:
pivot.jpg
I have tried rearranging the table, as I am sure the table layout is where the problem is. But still haven't had any luck.
This is the data entry table:
Data Chart.jpg
Also, I would really like to be able to have the pivot expand with the table, so I don't have to keep re selecting the data, as it grows. If that is even a thing!
Any help would be greatly appreciated!
Bookmarks