Multiple Field Selection for Pivot table Values Section

[pzeitlin]

Is there a simply way of selecting multiple fields for placement in
the 'Values' section of the pivot table field list in 2007?


Right now I have drag each field indvidually. This is painfully slow
when dealing with upwards of 10-20 different fields per pivot table.
The check box appears to only work placing the fields in the "Row"
section.

This would be tremendously helpful, if anyone had a suggestion.

Thanks.

v/r

Paul Z.