One of the difficulties of this form is that you're never standing over the person's sholder. It's always a challenge when you can't see the screen and ask questions in real time.
Somewhere in your table you calculate your subcategories or aging buckets, correct? For example on each record you determine which aging bucket it goes in?
Suppose your report is
FUND AMOUNT DUE DATE
A 5.00 1/1/2008
B 5.55 8/1/2008
C 1.00 7/1/2008
A 15.00 8/1/2008
You would add a field that has the following subcategories (I omited amount and due date)
And you want your summary to look like:
30 60 90
A 1 0 1
B 1 0 0
C 0 1 0
Or even more complex:
Can you correct me where I'm wrong on understanding the problem you want to solve and your solution? It will help to answer your question.
Also tags are what you use to help format your response. You can use code and /code surrounded by brackets to wrap arround your report sample to maitain the orgional format of the report.
I was afraid of that. You'll need to create X * Y calculated fields, where
X = # of Buckets you have (3 in your case, 30 60 90)
Y = # of Fields in each bucket ( 2 in your case, AMT and CNT)
30-CNT = if(BUCKET=30,1,0)
30-AMT = if(bucket=30,AMT,0)
Then in your summary, you will need to place these 6 new calculated fields in your measure box. Each will use the formula SUM to calculate the amount.