A pivot table can do what you want... Check out this link on getting started
with pivot tables.
http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
HTH...
Jim Thomlinson
"kbssailor" wrote:
Hi, all.
This is difficult for me to explain, but I'm trying to use the sum function
for one column in my subtotal but I would like two other columns to show me
what exists for that section.
Sales_Code PeopleSoftID SalesRep Sales
00014 117895 BAKKER 72.67
00014 117895 BAKKER 533.88
I would like the subtotal to look like:
Sales_Code PeopleSoftID SalesRep Sales
00014 117895 BAKKER Total 606.55
When I use the sum function at change in SalesRep, I get blank cells for
Sales Code and PeopleSoft ID in the subtotal rows, so when I collapse levels,
all I see is the SalesRep name and YTD Sales.
Is it possible to get data in the other columns?