Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table format
When I create a pivot table with two fields as row groupings (e.g., state and
county) the state is included in the output only when there's a change in the state value. Also, there's a subtotal for each state. I want the state to be on every row and I don't want subtotals. By the way...I'm using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table format
The row headings show once in a Pivot Table, and there's no setting you
can change, to force them to repeat. If you need to print 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 To turn off the subtotals, double-click on the field button for State Under Subtotals, choose None, then click OK Steve wrote: When I create a pivot table with two fields as row groupings (e.g., state and county) the state is included in the output only when there's a change in the state value. Also, there's a subtotal for each state. I want the state to be on every row and I don't want subtotals. By the way...I'm using Excel 2003. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table format | Excel Discussion (Misc queries) | |||
format pivot table | Excel Worksheet Functions | |||
Pivot Table Format | Excel Discussion (Misc queries) | |||
Help on Pivot Table Format | Excel Worksheet Functions | |||
how to format in pivot table | Excel Discussion (Misc queries) |