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