Pivot Table keeps changing!

actjfc

Active Member
Joined
Jun 28, 2003
Messages
412
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!
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

Active Member
Joined
Jun 28, 2003
Messages
412
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,630
Members
412,475
Latest member
JaredNAU
Top