PDA

View Full Version : Pivot Data Question



stanl
06-25-2007, 11:34 AM
The attached image shows issues I face with the data section of a Pivot table. The data is calculating stats for cities by year and defaults to showing all stats. If I set to only display 1 or 2 stats, there appears to be no way I can get back the original categories, short of going to Edit/Undo. Is there not a way to preserve these. Stan

matthewspatrick
07-07-2007, 08:06 AM
Can you post a copy of the workbook?