Create Subset chart/data

[djws]

Not sure if it's possible but....

I have a worksheet, attached. that has the sum of monthly sales. What I'd like is to have an option that I can click on the month's sales and then to the side or somewhere have the details of each sales person appear. Is this possible??

See my attached example.

[Kuskush]

This certainly would be possible. But where are the details of sales stored?
Your sample workbook does not seem to contain them.

[djws]

This certainly would be possible. But where are the details of sales stored?
Your sample workbook does not seem to contain them.

Your correct, I haven't inputed it yet, as I wasn't sure if I should do it in a certain way or something. But i could just imput them into a spreadsheet I guess with the month, then each sales persons name and their sales.

[djws]

Not sure if it's possible but....

I have a worksheet, attached. that has the sum of monthly sales. What I'd like is to have an option that I can click on the month's sales and then to the side or somewhere have the details of each sales person appear. Is this possible??

See my attached example.

Anyone Able to help me out with this??

[djws]

Not sure if it's possible but....

I have a worksheet, attached. that has the sum of monthly sales. What I'd like is to have an option that I can click on the month's sales and then to the side or somewhere have the details of each sales person appear. Is this possible??

See my attached example.

Sorry If I haven't been very clear, please see the sample2 i've attached, it's the actual worksheet.
As you'll see, there is a monthly $ field. This is the total $ of all sales ppl in the month. What I'd like to do is:

most importantly have the monthly monthly sales tab automatically totaled into the monthly sales $ colum in the report. Plus if possible automatically pull the date???

Secondly i'd like it to automatically count the billing persons (how many sales ppl billed that month) and then how many are above 7000 (bonus)

Is this possible or am I just asking something too complicated?
(it would be cool if while holding your mouse over the monthly $ it displayed the individual sales)