Pivot table question

C

Colin Macleod

Is it possible to vary the field settings by column in a pivot table? For
example, can I use Summarize by "Sum" for some columns and Summarize by
"Average" in others? I'm using Excel 2003

Thanks
 
M

Maria

Yes.

Just right-click each field, select Field Settings, and set your preference.

M.
 

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

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Excel does not accept text format! 0
Pivot Table: summarizing two different ways 0
Converting Letters To Numbers Summary??? 2
Pivot Table Counting Text Issue 0
SUM & OFFSET & PIVOT TABLE?? 0

Top