| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
microsoft multiple pivots
Not sure wherther i am just being thick??
I want to use to list to pull in data and have more than one row and more than one colomn and it is brining everything in row colomn and data rather than by fields why??? can anyone help me i thought it would show similar to a normal pivot table?? Thankyou Kate |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
microsoft multiple pivots
I don't quite understand what you're describing, but perhaps your data
fields are displayed vertically, and you want them horizontally. If so, you can use the technique described here to change them: http://www.contextures.com/xlPivot02.html kate wrote: Not sure wherther i am just being thick?? I want to use to list to pull in data and have more than one row and more than one colomn and it is brining everything in row colomn and data rather than by fields why??? can anyone help me i thought it would show similar to a normal pivot table?? Thankyou Kate -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
microsoft multiple pivots
After reading your question again, and the subject, perhaps you're
asking about multiple consolidation ranges. Those aren't the same as normal pivot tables, as described he http://www.contextures.com/xlPivot08.html kate wrote: Not sure wherther i am just being thick?? I want to use to list to pull in data and have more than one row and more than one colomn and it is brining everything in row colomn and data rather than by fields why??? can anyone help me i thought it would show similar to a normal pivot table?? Thankyou Kate -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
| Multiple Subtotal levels in Excel 2003 | Excel Worksheet Functions | |||
| Three (3) or multiple y-axes in Excel. | Charts and Charting in Excel | |||
| Remove Hyperlinks from multiple cells at the same time | Excel Discussion (Misc queries) | |||
| How do I create multiple worksheets from Page Pivots | Excel Worksheet Functions | |||
Linear Mode
