kinsdoe1234
New Member
- Joined
- Mar 25, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi all,
I have a set of daily sales, with dates down column A, and sales for Product 1, 2, 3, ... etc. in columns B, C, D, ..., etc.
Can obviously do some sums of historical months/quarters/years to get a YoY sales comparison for each individual product/total in a given period.
I'm looking for a way to automate a "X to Date" yoy % comparison as each new day's data comes in. For example, if I currently have sales data from 1/1/2019 to 2/3/2020, how could I go about constructing helper columns/formula to automatically compare the total sales from 1/1/2019 to 2/3/2019 against the total sales from 1/1/2020 to 2/3/2020, and then have that automatically update as I add more rows (days) of data when they come in?
Appreciate any help!
I have a set of daily sales, with dates down column A, and sales for Product 1, 2, 3, ... etc. in columns B, C, D, ..., etc.
Can obviously do some sums of historical months/quarters/years to get a YoY sales comparison for each individual product/total in a given period.
I'm looking for a way to automate a "X to Date" yoy % comparison as each new day's data comes in. For example, if I currently have sales data from 1/1/2019 to 2/3/2020, how could I go about constructing helper columns/formula to automatically compare the total sales from 1/1/2019 to 2/3/2019 against the total sales from 1/1/2020 to 2/3/2020, and then have that automatically update as I add more rows (days) of data when they come in?
Appreciate any help!