pivot table confusion

ive started out making a pivot table. it creates ok and i get what i need expect set of data is missing

the following code is with recording, but i have recoded this into structured VBA with objects etc, to make it more dynamic. see under

Please Login or Register  to view this content.

this is the code i've made with the help of some on here. but with the Order ID part i cannot get what i desire...i dont know how to add

Please Login or Register  to view this content.

into this:

Please Login or Register  to view this content.

grrr! thanks and sorry about all the code!!

ok solved. hope this helps someone.

Please Login or Register  to view this content.