Regarding Pivot Tables

E

Eric Svatik

I need to make a pivot table, how do i go about getting that started correctly?
 
E

Eric Svatik

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.
 
R

R Vaughn

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.
 
J

Jon Peltier

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
 
R

R Vaughn

Thanks.

Jon Peltier said:
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
_______
Click to expand...
 
Top