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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment