Hi Jason, I thought I saw this question got answered, but now the forum is showing zero responses. Did you get an answer? Or did you figure it out? If not, post a sample workbook of what you've go so far and I'm sure you'll get an answer -- the problem doesn't sound that difficult (but then what do I know). --Shawn
Thanks for the response. I have not received a response yet. I have attached a copy of the data and you can see that I am able to make the calculation that I want for any given date in time without using a table calculation. However, what I want to do is make this calculation for every Monday starting with a given date. Hopefully that can be accomplished with a table calculation.
Jason, I worked on this several hours last night and couldn't come up with anything workable. Sorry it's beyond my skill level. Maybe Joe or Richard will jump in. --Shawn
The way I would tackle this would be to modify the data source and add a table listing the dates of the Mondays - and define a cross product between that and your existing table. The answer will fall out easily then.
I don't think you can do it just with table calculations off your existing data source - though as always, I'll be happy for Joe to prove me wrong.