ok I think I got that part, thanks,
But what is happening is the Date column for example is ALL the same
formatting as the saleperson's name column or the item column, which is no
good.
My other question is: I'm trying to show for example a salesperson named
Gil, lets say he's has 3 different dates associated with him on sheet 1, and
I have 4 sheets.
On the master pivot table his name only appears once in my pivot table when
I should be able to see him 3 times for those different dates.
Do you know what I'm doing wrong here?
