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