There are multiple 'types of tables' depending on how your data is organized. This might explain the difference and show you why you are running into this »www.mediafire.com/file/dtvyymhyj ··· _10a.pdf
I am far from a guru, but I do use Pivot's quite often. I hope I have helped until a guru arrives. I now have to go peel 20 pounds of potatoes.