Using more than one summary function for a PivotTable data field

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

Guest

Hello Everyone

Please tell me what to do in order to display more than one summary
functions on a PivotTble. I want to show a maximum salary and and a minimum
salary on the same pivot table.

Thank you in advance.
 
Drag the same field to the data area twice.
Right-click on the field heading, and choose Field Settings
For one field, choose to summarize by Min, and for the other, choose to
summarize by Max.
 
Hi

drag salary to the data area twice, right mouse click on one & choose field
settings - change to min
do the same for the other & change to max

Cheers
JulieD
 
You must log in or register to reply here.

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 summary functions 1
Pivot table calculated field 2
need help with creating a formula which checks more than 40 cells 1
Returning a label rather than a number in pivot table field 1
PivotTable lookup 2
Pivot Table Summary Error? 6
Please Help w/ Functions 2
Formula for calculation based on multiple conditions 2

Back
Top