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.

--
HTH,
George


"GeorgeK@Novagard" wrote in
message ...
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.