GiventoFly
New Member
- Joined
- Nov 4, 2014
- Messages
- 3
If wrong forum, please move.
What I have is 104 weeks of sales data and I'd like to find a way that I could sum up Sales, Qty, GP for last 52, 26, 13, 4, and last week. Then i'd like to find the % diff vs. the year prior 52, 26, 13, 4, LW.
Example of what is looks like after it's done:
Columns left to right: Market; Sales Person; Customer; Category; 52 Wk chg%, 26 wk chg%, 13 wk chg%, 4 wk chg%, LW chg %
I'd also like it to be in a pivot table, so that it is easily viewed by different sales people and they can collapse data they don't need.
Right now, the way I have to do it is put it into a pivot table, then group the weeks and vlookup into another sheet based on a concatenated field.
I was hoping there would be a way I could make this report dynamic, where all I have to do is drop in the 104 weeks data every Monday and it updates automagically.
Any help on where I should start would be appreciated.
My weeks are setup at YYYYWW. My data requires me to concatenate my year and week numbers along with a text formula for the single digit weeks.
Thanks,
What I have is 104 weeks of sales data and I'd like to find a way that I could sum up Sales, Qty, GP for last 52, 26, 13, 4, and last week. Then i'd like to find the % diff vs. the year prior 52, 26, 13, 4, LW.
Example of what is looks like after it's done:
Columns left to right: Market; Sales Person; Customer; Category; 52 Wk chg%, 26 wk chg%, 13 wk chg%, 4 wk chg%, LW chg %
I'd also like it to be in a pivot table, so that it is easily viewed by different sales people and they can collapse data they don't need.
Right now, the way I have to do it is put it into a pivot table, then group the weeks and vlookup into another sheet based on a concatenated field.
I was hoping there would be a way I could make this report dynamic, where all I have to do is drop in the 104 weeks data every Monday and it updates automagically.
Any help on where I should start would be appreciated.
My weeks are setup at YYYYWW. My data requires me to concatenate my year and week numbers along with a text formula for the single digit weeks.
Thanks,
Last edited: