Excel 2007 : YTD sales to goals Pivot Table

**lyn402** · 04-21-2012, 02:00 PM

I am new to pivot tables. Anyone interested in helping. I have attached the short version of my data. Basically, I need a table that reports:
1. weekly totals by rep, by dept
2. monthly totals by rep, by dept
3. qtrly totals./...
4. YTD totals...

I also would like to add weekly/monthly/annual goals...by depot, rep, total company. I have also attached a copy of what my report looks like just using a simple excel spreadsheet to help identify what I am looking for. (be sure to scroll to the bottom)
Thank you!Data 1.xlsx 0408.2.xlsx

**FDibbins** · 04-21-2012, 07:40 PM

Lyn, this is a great place to come for answers, and there was no suggestion that you intentionally broke any rules. The reason threads need a good, decsriptive titel, is to give us some idea of what you are looking for. There are 1000's of posts, and not every1 has the time to open a thread to see what the poster needs to achieve, so many just look at the title, and if they cant help based on whatthe title says, they move on to the next thread.

Hope this helps?

**Cutter** · 04-21-2012, 08:04 PM

@FDibbins
I think the OP went away mad. (I didn't think the title was all that bad, though.)
I noticed that you need to edit your signature - point 3 - because there's no "little scale" anymore.

**FDibbins** · 04-21-2012, 08:27 PM

yes i think you are right lol

and thx, i will take a look at my signature and see what you mean

**lyn402** · 04-22-2012, 10:17 AM

Thank you for your advice...I will edit my title. I am looking forward to hearing from the experts out there!!

Originally Posted by FDibbins

Lyn, this is a great place to come for answers, and there was no suggestion that you intentionally broke any rules. The reason threads need a good, decsriptive titel, is to give us some idea of what you are looking for. There are 1000's of posts, and not every1 has the time to open a thread to see what the poster needs to achieve, so many just look at the title, and if they cant help based on whatthe title says, they move on to the next thread.

Hope this helps?