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!
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!