I'm trying to create a report that shows sales by week (date part of ship date) as rows and using if thens to create the totals by year (also date part as ship date) as columns. But I'm getting multiple rows so my report looks like this:

Week 1 | Blackberries | 2016 Amount - $123.45 | 2017 - $0
Week 1 | Blackberries | 2016 Amount - $0 | 2017 - $123.45

and so on....

I think it's a group by problem but I don't know how to do this, create a subgroup or running total to get this right? Does anyone have an example they could show me?

Thanks!