Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding Pivot Tables
I need to make a pivot table, how do i go about getting that started correctly?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding Pivot Tables
Check out this link...
http://peltiertech.com/Excel/Pivots/pivotstart.htm -- HTH... Jim Thomlinson "Eric Svatik" wrote: I need to make a pivot table, how do i go about getting that started correctly? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding Pivot Tables
So they are pretty simple to use then.
Ok thanks and i will try these out and Go pivot table happy. Have an awesome weekend. "Jim Thomlinson" wrote: Check out this link... http://peltiertech.com/Excel/Pivots/pivotstart.htm -- HTH... Jim Thomlinson "Eric Svatik" wrote: I need to make a pivot table, how do i go about getting that started correctly? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding Pivot Tables
When setting up the source data in a pivot table, is there a way to assign
rows as fields and columns as records? Excel automatically sets each row of the source data as a record with field names located in the top cells of the columns. I typically prefer this standard layout, but sometimes find it useful to store and display source data with the columns as records. "Jim Thomlinson" wrote: Check out this link... http://peltiertech.com/Excel/Pivots/pivotstart.htm -- HTH... Jim Thomlinson "Eric Svatik" wrote: I need to make a pivot table, how do i go about getting that started correctly? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regarding Pivot Tables
Thanks.
"Jon Peltier" wrote: Pivot tables require data to be stored with rows as records. If you need a different layout for display, perhaps you could start with the source data in the proper orientation and use links or a pivot table to generate a display view on another sheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "R Vaughn" <R wrote in message ... When setting up the source data in a pivot table, is there a way to assign rows as fields and columns as records? Excel automatically sets each row of the source data as a record with field names located in the top cells of the columns. I typically prefer this standard layout, but sometimes find it useful to store and display source data with the columns as records. "Jim Thomlinson" wrote: Check out this link... http://peltiertech.com/Excel/Pivots/pivotstart.htm -- HTH... Jim Thomlinson "Eric Svatik" wrote: I need to make a pivot table, how do i go about getting that started correctly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
synchronising pivot tables | Excel Discussion (Misc queries) | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |