Pivot Table sort -Excel 2007
I have an Excel spreadsheet with data in column 1 that is in an order which
only makes sense to me. I need to leave it in this order when I create the
Pivot Table. When I create the Pivot Table I drag this field to ROW LABELS.
At this point it will sort A-Z or Z-A. I want it to stay just like it shows
on my spreadsheet. I have checked the forum and have yet to find an answer.
--
Lisa Fornal
|