Multiple formulas in subtotal

K

kbssailor

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?
 
K

kbssailor

Thanks, so much Jim! I always forget about pivot tables. I made a quick one
and it works perfectly well for what I need.

Thanks again!
 

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

Top