That was the second option I was considering to make the calculations  
work faster--but there are multiple other fields other than day of  
week, month and year that the data is getting sorted and compiled by  
and all the intermediary calculations are of value in evaluating the  
totals and other calculations that involve the intermediary sort  
calculations--so not as simple as just re-doing a few links and  
calculations at the upper level, unfortunately.  However, I am not  
ruling that option completely out.

Thanks,

Sue


On May 5, 2010, at 10:37 PM, richardsrussell tds.net wrote:

> I may be totally misunderstanding the way you're doing this, but I  
> infer from what you wrote that you're aggregating a bunch of days  
> into a week, then aggregating those CALCULATED week totals into a  
> month, then aggregating those CALCULATED month totals into a year,  
> and so on.
>
> If that's the case, it would probably be easier if you had  
> calculations within each record that simply spat out separate fields  
> for the week, month, and year numbers, then did the totals on each  
> of those individually.
>
> For instance, today is 2010 May 5. If I create a record with that  
> date auto-filled, it could have calculated fields for Week = 18,  
> Month = 5, Quarter = 2, and Year = 2010. Then you could do your  
> sorting and totalling on ANY of those fields individually. Heck, if  
> you wanted to, you could even have a Weekday field that would let  
> you isolate all activities on Wednesdays (or any other day) for  
> subsequent analysis.