Name items in Pivot Tables?
I have a pivot table based on multiple data sources (12 months of the year).
The page field list shows as Item1, Item2 etc which I (eventually) figured
out is the ranges in alphabetical order. I'd like these to show as Jan, Feb
etc - is there a way? I tried naming the ranges but no luck... , seems such
an obvious thing to want to do!! Any help much appreciated
Sheila
|