Over-thinking, to set up info

[Befuddled2011]

I have a comma dilimeted file and so i turn it into a table. Im told to do the following:

-----S]ort by discount level. Have discounts increased sales volumes? Is there any discount level that appears to be more effective than others?
----Graph sales over time to see trends. Are there any peaks and lows in sales? Is there any time of year in which sales are highest? Lowest?
----Pivot the data to see total sales by quarter, country, category, and salesperson. Are there any highs? Are there any lows that need to be addressed?
----Subtotal the data. How are quarterly sales totals? Sales totals by salesperson? By Country?
*Challenge Option: Perform What-If Analysis. What if prices were raised by a certain percentage with a slight decline in sales? What combination of price increases and decline in sales makes most sense?

On the main sheet I sorted the data by the level, but unsure how to do the next. I keep going in circles and the graphs I pull have too much information to look correct or doesn't look like it has the info I need at all. Im frustrated with this completely because I've done so well before this and for some reason I can't figure out how to set this up to show this info without over-killing the actual steps I take.

Can someone please talk to me about this and help me figure out what to do?? I was up until 330am this morning and I can't stay up any later tonight. I just need someone to guide me to my answer and possibly smack me in the head because I'm sure this is a very simple solution.

Please Help!! Thank you!!!

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.