row fields in pivot tables

[Guest]

I was wondering if you could answer a question about formating information on
Pivot Table spreadsheets in Excel.

You know how one can alloacte column headings in the pivot table layout to
either Page , Row, Column, or Data. Well, when you assign more than one
column heading to Row it creates a hierarchy of levels on different rows. How
does one get it not to do this so you can have this information on the same
row?

Please reply when you get a chance.

Thank you.

Best Wishes,


Saeed

 

[Dave Peterson]

I don't think you can and still keep it a pivottable.

I copy the sheet and then fix that up the way I want (remove subtotals mostly).
Then I convert to values (I lose the pivottable on this copy).

Then I use one of the techniques on Debra Dalgleish's site to fill those rows
with the value above it.

http://www.contextures.com/xlDataEntry02.html

 

[Guest]

I think I know what you're trying to do....See if this works for you:
Click and Hold on the column title you want to spread across the Pivot
Table. Then drag it over the Row Totals and release. That should take those
categories and spread them across the columns.

Example:

Name....Category....Total
Dave......Cat1...........10
..............Cat2...........30
Steve.....Cat1...........50
..............Cat2...........40

Drag Category over Total and release. Then you'll get:
Name....Cat1.....Cat2....Total
Dave......10........30.......40
Steve.....50........40.......90

Is that what you're looking for?