Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table formatting
greetings! if i've got three items in the "row" section of pivot table
layout, is it possible to have the value of the first and second items displayed on each line? the default table currently has the first item on the first line only, second items will appear once at the top of each of their sections, then the third item will appear on each line. guessing this is just how pivot output pops out but you folks can help me find out definitively. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table formatting
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. To create a table with a heading on each row, you could copy the pivot table, paste it as values in another location, and fill in the blanks, using the technique shown he http://www.contextures.com/xlDataEntry02.html mwam423 wrote: greetings! if i've got three items in the "row" section of pivot table layout, is it possible to have the value of the first and second items displayed on each line? the default table currently has the first item on the first line only, second items will appear once at the top of each of their sections, then the third item will appear on each line. guessing this is just how pivot output pops out but you folks can help me find out definitively. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Worksheet Functions | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Pivot Table Formatting | Excel Discussion (Misc queries) |