Hi, Friends!
I've really been stuck on this problem for a long time, and I haven't been able to google myself into a solution.
I have a data set that updates weekly on Saturdays. I'm trying to group the 52 week's worth of dollars $ and units U by the various timeframes in on 1 page.
I was going down a path of using a helper table, but I'm really stuck. In the attached file I have the data table (condensed), the helper table, a tab that shows what I am trying to achieve, and my current pivot table.
Thanks in advance for taking the time to help. You all are amazing!
D
I've really been stuck on this problem for a long time, and I haven't been able to google myself into a solution.
I have a data set that updates weekly on Saturdays. I'm trying to group the 52 week's worth of dollars $ and units U by the various timeframes in on 1 page.
I was going down a path of using a helper table, but I'm really stuck. In the attached file I have the data table (condensed), the helper table, a tab that shows what I am trying to achieve, and my current pivot table.
Thanks in advance for taking the time to help. You all are amazing!
D