Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 .... |
#2
|
|||
|
|||
Answer: Pivot Tables show actual name rather then "Column Labels"
The reason 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 is because it is a default setting in Excel. However, you can easily change this setting to show the actual names of the dimension fields.
Here are the steps to show the actual names of the dimension fields in Excel 2007 Pivot Tables:
Now, your Pivot Table should show the actual names of the dimension fields in the header instead of "Column Labels" and "Row Labels". This setting will also apply when you print the Pivot Table.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables show actual name rather then "Column Labels"
Select a cell in the pivot table
On the ribbon, click PivotTable Tools, then click the Design tab In the Layout group, click Report Layout Choose Show in Outline Form or Show in Tabular Form SQL2005_rocks wrote: 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 ... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables should show actual name rather then "Column Labels"
Thanks Debra, that gets me "Country | State | City ..." but it still does
not show the name of the dimension ("Customer Geography"). How about a better example: In AdventureWorks if you choose ShipDate.Calendar as a dimension, Excell 2007 only shows: "Calander Year | Calendar Semester | Calendar Quarter...". There is NO WAY to tell if this is the ShipDate or OrderDate or any other date! This seems like a show stopper Excel 2007 bug. Tom "Debra Dalgleish" wrote: Select a cell in the pivot table On the ribbon, click PivotTable Tools, then click the Design tab In the Layout group, click Report Layout Choose Show in Outline Form or Show in Tabular Form SQL2005_rocks wrote: 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 ... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables should show actual name rather then "Column Label
Have you solved the problem? Please share your solution. Thanks
"SQL2005_rocks" wrote: Thanks Debra, that gets me "Country | State | City ..." but it still does not show the name of the dimension ("Customer Geography"). How about a better example: In AdventureWorks if you choose ShipDate.Calendar as a dimension, Excell 2007 only shows: "Calander Year | Calendar Semester | Calendar Quarter...". There is NO WAY to tell if this is the ShipDate or OrderDate or any other date! This seems like a show stopper Excel 2007 bug. Tom "Debra Dalgleish" wrote: Select a cell in the pivot table On the ribbon, click PivotTable Tools, then click the Design tab In the Layout group, click Report Layout Choose Show in Outline Form or Show in Tabular Form SQL2005_rocks wrote: 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 ... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables should show actual name rather then "Column Label
I found the solution by playing around the report. All you need to to do is to chage the default report layout under the design menu from "Compact" to "outline" or "tabular" "KC" wrote: Have you solved the problem? Please share your solution. Thanks "SQL2005_rocks" wrote: Thanks Debra, that gets me "Country | State | City ..." but it still does not show the name of the dimension ("Customer Geography"). How about a better example: In AdventureWorks if you choose ShipDate.Calendar as a dimension, Excell 2007 only shows: "Calander Year | Calendar Semester | Calendar Quarter...". There is NO WAY to tell if this is the ShipDate or OrderDate or any other date! This seems like a show stopper Excel 2007 bug. Tom "Debra Dalgleish" wrote: Select a cell in the pivot table On the ribbon, click PivotTable Tools, then click the Design tab In the Layout group, click Report Layout Choose Show in Outline Form or Show in Tabular Form SQL2005_rocks wrote: 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 ... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables should show actual name rather then "Column Label
That's what I suggested in my earlier reply:
"Debra Dalgleish" wrote: Select a cell in the pivot table On the ribbon, click PivotTable Tools, then click the Design tab In the Layout group, click Report Layout Choose Show in Outline Form or Show in Tabular Form KC wrote: I found the solution by playing around the report. All you need to to do is to chage the default report layout under the design menu from "Compact" to "outline" or "tabular" "KC" wrote: Have you solved the problem? Please share your solution. Thanks "SQL2005_rocks" wrote: Thanks Debra, that gets me "Country | State | City ..." but it still does not show the name of the dimension ("Customer Geography"). How about a better example: In AdventureWorks if you choose ShipDate.Calendar as a dimension, Excell 2007 only shows: "Calander Year | Calendar Semester | Calendar Quarter...". There is NO WAY to tell if this is the ShipDate or OrderDate or any other date! This seems like a show stopper Excel 2007 bug. Tom "Debra Dalgleish" wrote: Select a cell in the pivot table On the ribbon, click PivotTable Tools, then click the Design tab In the Layout group, click Report Layout Choose Show in Outline Form or Show in Tabular Form SQL2005_rocks wrote: 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 ... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronising pivot tables | Excel Discussion (Misc queries) | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
2 Pivot tables on 1 sheet | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |