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.