Pivot Table Question

[YQG]

I have a list of Sales people showing each sale made by $ amount

eg

smith 11,250
smith 1, 000
jones 2,220
jones 900

I can get the pivot table to count the # of sales; sum the $ sold, etc., by salesperson, but I would also like it to count the # of sales between $ amounts, eg # sales < $1000; # sales between $1000 and $2000 etc.

So in the end I could see

Name - # Sales - $ Sold - # sales <$1000 - etc


Can anyone help.
Thanks to all for reading this, whether you can help or not.

S.

 

[GorD]

Something like this

Book1
	A	B	C	D	E	F	G	H
1	name	sales
2	smith	11250		Sum of sales	sales
3	smith	10		name	0-999	2000-2999	11000-11999	Grand Total
4	jones	2220		jones	900	2220		3120
5	jones	900		smith	10		11250	11260
6				Grand Total	910	2220	11250	14380
Sheet1

Put your sales amounts both in the data field and the column field.

Then right click on the column headers in pivot table and select the group option

 

[YQG]

Thank GorD, that's exactly what I want but when I try to Group, excel is telling me "Cannot group that selection" ?? I had tried that already but when I got the error message I thought I was doing something wrong... obviously I am, I'm just not sure what. Any thought on why it won't group for me??

Thanks

 

[YQG]

Okay... I tried using a different $ amount field and it worked... it just won't on the $ amount field I want ???? Ahhh.... I had blank cells..... I've replaced blanks with 0.00 now it works.

Thanks GorD !!