Hi @jkv0019 ,
Welcome to Alteryx. Usually, there are multiple ways to solve a problem with the tool. Here's my suggestion:
1. Transpose your data, basically you want your dates to run vertically in a column as opposed to rows.
2. If the date is not already in a date value, you'll want to change it -- Alteryx reads dates as YYYY-MM-DD. If your query doesn't already aggregate the data at a week view, you can do so by using the link provided by @Joe_McCoy
3. Sort your data, first group by any necessary dimensions -- product group, location, etc. then sort by week date
4. Use the multi-row formula to perform a calculation based off the row above [Active Row: Value] - [Row-1:Value] -- or slightly different if you are looking for % change
5. If desired, add a formula to describe your week date value -- 2021: Week 2 -- parsing the date value or using a datetime formula
One other note, this section of the forum may not get as many views as a more general section -- https://community.alteryx.com/t5/Alteryx-Designer-Discussions/bd-p/designer-discussions -- when I have a technical or help question, I post it here -- there are alot of helpful Alteryx users across the world.
Good luck