Pivot Table keeps changing!

[actjfc]

Friends,

I have a database of buyers. They buy during all months different products A,B,C,D,E, and F. I would like to use pivot tables to analyze seller by page in a table that shows Months\Products.

Some buyer do not buy in some months, some buyers do not buy all products.

The size and shape of the table keeps changing if a seller do not buy during one month or not buy a particular product.

MY QUESTION:
How can I set up the pivot table to ALWAYS show the same size and shape of pivot tale with ALL months and ALL products in the headings regardless of the type of buyer?

Thanks!

 

[PaddyD]

if you want all the sellers / products / months represented, independent of whether they appear in the data, then a pivot table is probably not the way to go - rather, set up the catgegories in advance & return the summaries with formulas.

 

[actjfc]

OK! However, I always think that if I cannot do something in Excel is because I do not know how to do it, not because it cannot be done.

I mean, pivot tables are powerful, and there should be a way to show all months and products regardless if the seller buys. Just for the sake of my knowledge, how can this be done using pivot tables? if so how?

Maybe, it is not worthy to do it this way, but I would like to know how this can be done.

Thanks!