Using more than one summary function for a PivotTable data field

A

Almamba

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.
 
D

Debra Dalgleish

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.
 
J

JulieD

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
 

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
Returning a label rather than a number in pivot table field 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
PivotTable - feature like "value range" or "slices" available on regular fields? 0
how to return "summary" of all non-blank cells plus their headers 10
Multiple worksheet summary 4
Multiple lookup values and adding multiple rates across together 5
PivotTable lookup 2

Top