When I create a pivot table, with multiple data fields, the data
fields, by default, show up as different rows. I prefer to have a
different column for each data field, and I can get the data into
columns by selecting any of several of the default report format.
However, I don't really care to get all the formatting that comes with
the available formats. How can I get my pivot tables to display data
fields in separate columns without first picking a default Pivot Table
format?

Thanks

Ken

Grab the data field you want as a column by left-clicking on it and dragging
it to the column area and dropping it.
--
HTH,
Gary Brown

If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.



" wrote:

When I create a pivot table, with multiple data fields, the data
fields, by default, show up as different rows. I prefer to have a
different column for each data field, and I can get the data into
columns by selecting any of several of the default report format.
However, I don't really care to get all the formatting that comes with
the available formats. How can I get my pivot tables to display data
fields in separate columns without first picking a default Pivot Table
format?

Thanks

Ken

or just create the table with the desired data fields as columns to begin with
--
HTH,
Gary Brown

If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.



" wrote:

When I create a pivot table, with multiple data fields, the data
fields, by default, show up as different rows. I prefer to have a
different column for each data field, and I can get the data into
columns by selecting any of several of the default report format.
However, I don't really care to get all the formatting that comes with
the available formats. How can I get my pivot tables to display data
fields in separate columns without first picking a default Pivot Table
format?

Thanks

Ken

Gary

Thanks, but, I guess I was not completely clear. When I do as you
suggested, I get a new column for each unique data entry (a lot of
columns) which is not what I want. I drag ordered qty, rec'd qty and
issued qty to the data area. Then I have, for each item (my row area
variable) an additional row summarizing the three data items. I then
select an autoformat for the pivot table, and the three data items
that were initially in rows become three columns headed ordered qty,
rec'd qty and issued qty which is exactly as I want; but, I get a
bunch of other formatting that I don't want. What I want to do, is
simply have the three data area variables generate three columns
immediately rather than three rows.

Thanks again for your time.

Ken

On Aug 21, 12:48 pm, Gary Brown
wrote:
or just create the table with the desired data fields as columns to begin with
--
HTH,
Gary Brown

If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.



" wrote:
When I create a pivot table, with multiple data fields, the data
fields, by default, show up as different rows. I prefer to have a
different column for each data field, and I can get the data into
columns by selecting any of several of the default report format.
However, I don't really care to get all the formatting that comes with
the available formats. How can I get my pivot tables to display data
fields in separate columns without first picking a default Pivot Table
format?

Thanks

Ken- Hide quoted text -

- Show quoted text -