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
 
Top