Matrix report (double row footer)

I have data that I would like to pivot in a matrix style report. The problem
is that I need two lines in my footer section and I am unable to find a way
to "insert" an additional row into my footer and use a calculated field to
calc the avg below the totals.
Year Month Group A Group B
1999 Jan 10 20
1999 Feb 10 20
.
.
Annual Total 20 40 Footer Line 1
Monthly Avg 10 20 Footer Line 2
Is there a way to do this?I have the exact same query. Anybody out there able to help.
"skmonroe" wrote:
> I have data that I would like to pivot in a matrix style report. The problem
> is that I need two lines in my footer section and I am unable to find a way
> to "insert" an additional row into my footer and use a calculated field to
> calc the avg below the totals.
> Year Month Group A Group B
> 1999 Jan 10 20
> 1999 Feb 10 20
> .
> .
> Annual Total 20 40 Footer Line 1
> Monthly Avg 10 20 Footer Line 2
> Is there a way to do this?

Matrix Questions

I have been running into a couple of problems with my Matrix style reports:

First my Matrix is a drillthrough that looks like this

Year Group QuarterGroup Detail name Detail name Group1 Group2 Group3 Detail data Detail Data

1. How do I interactively sort by a detail column name, right now I'm using a switch statement in the Group1-3 sorts to allow the user to sort, the problem is that the user has to choose how to sort before running the report and I can't set the sort direction. Sort direction doesn't take an expression.

2. How do I collapse a Detail name column, when I set the visible property to false on the text boxes in the column all they disappear but the Year and Quarter Group textboxes don't resize.

3.

I would also like to have an drillthrough matrix report that looks like this

Year Group QuarterGroup Detail % Change over previous time period Group1 Group2 Group3 Detail data % of change from last quarter or year

What expression should I place in the % of change from last quarter or year box?

Anybody?