pivot layout

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set up a pivot table from the wizard with many data fields
to go horizontally across the page rather than vertically down the page? (eg
total sum, average, max, min in columns B-E rather than rows 5-8).

Thanks
 
Not sure if this can be done using the Wizard, but once you've set up
your table and begun adding data, drag the gray "Data" box to the right
field "Total" I think. This will place your data in separate columns
instead of rows. As you drag new items to the data field it will
populate a new column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table 'Grand Total' question, average instead of sum 4
Pivot table Average with [h]:mm format 5
Pivot table data layout - columns to rows 1
Comparing % Differences From in Pivot Tables 2
pivot table defaults 2
Pivot Table Layout Help 1
Pivot Table - 3
Average of % in pivot table 1

Back
Top