Learn Excel Episode 970: Missing Months

Posted in Companies, Podcasts on March 18, 2009



Michael from Shanghai asks about missing data in a pivot table. If some customers have data from every month and other customers have data from only a few months, the pivot table will change shape as you select new customers from the filter. Episode 970 will show you the hidden setting to prevent this problem.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel