How do I get PivotTable data results to show in columns instead ro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GeorgeK@Novagard - 17 Apr 2008 16:05 GMT

In Pivot Tables you have your data that you drag and drop as page, column and
row separators for your data. In the actual data field you can have sum,
count , average,... fields to choose from for what you want to see. This
information always shows results by row. I want to know if you can see the
results in columns. An example would be that I look at Count and average for
my given data. The count is in one row and the average is in the nixt row.
I would like the results to show the count in the first row and the average
to be in the same row , next column. Can this be done and How? I have tried
to use the PivotTable Table Options athat shows rows then columns or columns
then rows, but this does not change anything in my results no matter wich one
I choose.

Reply to this Message

George Nicholson - 17 Apr 2008 17:14 GMT

You need to Drag & Drop to make this change.

-Click on one of the grey labels for one of the fields in your Data Area.

-*Carefully* drag that label up and to the right just a *little* bit. (Pivot
the field label on itself *within* the Data Area). Very little movement is
required for this. Barely a twist of the wrist.

Very easy, but you might need a little bit of trial and error practice.

Signature

HTH,
George

> In Pivot Tables you have your data that you drag and drop as page, column
> and
[quoted text clipped - 15 lines]
> one
> I choose.

Reply to this Message

GeorgeK@Novagard - 18 Apr 2008 17:43 GMT

I am using Excel 2003. I tried to do what you said but the field either
stays where it is or jumps above the other field. I am doing this in a pivot
table with only two data fields, count and average.They will not show side by
side

> You need to Drag & Drop to make this change.
>
[quoted text clipped - 25 lines]
> > one
> > I choose.

Reply to this Message

George Nicholson - 22 Apr 2008 21:08 GMT

I'm using Excel 2003, and while it may require trial and error, it is
possible.

Signature

HTH,
George

>I am using Excel 2003. I tried to do what you said but the field either
> stays where it is or jumps above the other field. I am doing this in a
[quoted text clipped - 40 lines]
>> > one
>> > I choose.

Reply to this Message

GeorgeK@Novagard - 23 Apr 2008 18:36 GMT

Any chance you could send me a file with the example? I tried slowing my
pointer down but still could not accomplish the task. You can send it to
gkupchik@novagard.net Thanks!

> I'm using Excel 2003, and while it may require trial and error, it is
> possible.
[quoted text clipped - 43 lines]
> >> > one
> >> > I choose.

Reply to this Message