Prev: Help with writing a macro to create a list
Next: Combining data from 6 workbooks into one master
From: kbssailor on 3 Feb 2010 10:13
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?
From: Jim Thomlinson on 3 Feb 2010 10:24
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?
From: kbssailor on 3 Feb 2010 10:37
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!

"Jim Thomlinson" wrote:

> 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?
 | 
Pages: 1
Prev: Help with writing a macro to create a list
Next: Combining data from 6 workbooks into one master