Multiple formulas in subtotal
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?
|