Pivot Table - fixed number of columns

[brpeter]

Hello, I have a pivot table which shows the revenue by customer for years 2011 and 2012, one column for each year month by month. Because the year 2012 has only just begun, revenue data is not available for all customers. I would like the pivot to have a fixed layout where January has two columns for 2011 and 2012, February has two columns for 2011 and 2012 and so on for each customer even though there might not be data available for 2012. For January this is not a problem because my data extract includes January but for the remainder of 2012 I have no data, so the column 2012 disappears for the months February, March etc. I must be able to select each customer and still see both columns 2011 and 2012 for each month even though there might not be any data in the 2012 column.

Can somebody help me please?

Thanks in advance.

 

[Andrew Poulsom]

Welcome to MrExcel.

You will need to add some dummy data to your source if it doesn't exist.

 

[brpeter]

Thanks for a quick reply. I was afraid that I had to add dummy data, so I guess that is what I will do. Thanks again.