I created a pivot table in Excel 2003 that recap sales. The pivot table is filtered using the sales rep ID in the PAGE section. The ROW includes sales type (for example, grocery, meat, produce, etc.) and customer (ID and name) while the COLUMN includes period number. The DATA recapped is sales dollars.
The problem is that I want the pivot table to display all of the sales rep's customers (by sales type) even if they do not have any sales. I want to be able to include those customers that have no sales with those that do.
I tried to select the "Show items with no data" box in the PivotTable Field for the customer ID; however, I receive the error "There is not enough memory available to create the PivotTable report. To make more memory available, try the following: Reduce the number of column or row fields you include in the PivotTable report. Close files or programs you aren't using".
The solutions offered do not work for me as I can't reduce the number of rows because I want to be able to display all of the customers for the respective sales rep and sales type.
I appreciate any help that you can provide.
P.S. In my current project, I link the pivot table to data in Access; however, I have also had this problem when the data is in the same Excel spreadsheet.