Susan: I am not sure if this is under the general rubric of headings, but I have provided source material for a staff member who produces reports that have columns at the top of the Pivot table reports, and he is working with one set of data ( fairly large set), and under one "pivot" he has 5 across the top, but he changes the selection and the display drops from 5 to 3 columns. I seem to recall that there is a solution within a pivot table that will use the data that is there in the data, but does not display, however, I have been searching for a solution, as well as trying to find the exact article I recall, but a trainer here wants to plug the back end into an access data source, which seems to be overdoing it. However, I am stuck in that the data to display is not something I can bring out into public forums, anyway, I don't know what sort of info you would need in this case, since the pivot table would be more consistent with 5 columns, since the rest of the data displays that way. I have been searching Bill jelen's books on the Pivot tables but I can't seem to find exact info.
Apologies if this sounds waffly, thats what pivot tables feel like sometimes
Anyway, I had helped the staff member get so far and not farther; feels like a shakespearean quandry, to go back takes the same effort as to go forward ...