Pivot Tables show actual name rather then "Column Labels"
Why do Excel 2007 Pivot Tables show the text "Column Labels" and "Row Labels"
in the header rather than the actual name of the dimension fields in use?
I've found the "Field Headers" option / button to hide them, but Id really
like to see what is actually being used. This applies to printing too.
In other words, rather then:
Internet Sales Amount Column Labels
Row Labels 0-1 miles ...
Australia $1,322,953.97
Canada $232,546.64
....
I'd rather have:
Internet Sales Amount Commute Distance
Customer Geography 0-1 miles ...
Australia $1,322,953.97
Canada $232,546.64
....
|