Hello,
I am doing analysis on products and seeing what the best performing week was for them. I'm doing this for the year 2018 and 2019.
On the "Best Week" sheet, which is a Pivot Table (it pulls from a data tab with the raw sales info):
Product #'s are listed in column B.
Years are listed in row 5.
Weeks are listed in row 6.
C7:CN7970 currently have the $ amounts. More will be added week-to-week.
On the "Products" sheet:
Product #'s are listed in column B - and will be shifted around as filters are applied for looking at top revenue drivers, etc. so a static formula will not work.
I have a title for "Best 2018 Week" which needs to find the best week (highest $) by item - so we know what week was the best.
Another title is "Best 2018 Week Rev" which will look at that "Best 2018 Week" and display the revenue that product earned.
Here is a image of what I'm talking about: https://i.ibb.co/jHK3Ht6/Capture.png
I greatly appreciate any assistance. Thank you in advance!
I am doing analysis on products and seeing what the best performing week was for them. I'm doing this for the year 2018 and 2019.
On the "Best Week" sheet, which is a Pivot Table (it pulls from a data tab with the raw sales info):
Product #'s are listed in column B.
Years are listed in row 5.
Weeks are listed in row 6.
C7:CN7970 currently have the $ amounts. More will be added week-to-week.
On the "Products" sheet:
Product #'s are listed in column B - and will be shifted around as filters are applied for looking at top revenue drivers, etc. so a static formula will not work.
I have a title for "Best 2018 Week" which needs to find the best week (highest $) by item - so we know what week was the best.
Another title is "Best 2018 Week Rev" which will look at that "Best 2018 Week" and display the revenue that product earned.
Here is a image of what I'm talking about: https://i.ibb.co/jHK3Ht6/Capture.png
I greatly appreciate any assistance. Thank you in advance!
