Home |
Search |
Today's Posts |
#1
|
|||
|
|||
row fields in pivot tables
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 |
#2
|
|||
|
|||
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 saeed wrote: 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 |
#3
|
|||
|
|||
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? -- Regards, Ron "saeed" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
About Hiding Fields in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Pivot Tables, calculated fields | Excel Discussion (Misc queries) | |||
Pivot Tables multiple data fields | Excel Worksheet Functions |