Pivot Table - fixed number of columns

brpeter

New Member
Joined
Feb 17, 2012
Messages
2
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.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to MrExcel.

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

brpeter

New Member
Joined
Feb 17, 2012
Messages
2
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,263
Messages
5,769,117
Members
425,518
Latest member
seothaeng

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top