how can i do multiple sort in pivot table
G Gary L Brown Jan 26, 2006 #2 Right-click on each field, select 'Field Settings', select 'Advanced', select the desired sort option in the AutoSort options section. HTH,
Right-click on each field, select 'Field Settings', select 'Advanced', select the desired sort option in the AutoSort options section. HTH,