Monday, February 20, 2012

Positioning Subtotal in Matrix

Is there a way to re-position the subtotal in a matrix report such that the
subtotal is displayed at the beginning of the report instead of at the end.
Currently:
Q1 10
Q2 5
Q3 10
Q4 3
Total 28
Need:
Total 28
Q1 10
Q2 5
Q3 10
Q4 3
Thanks!You can change the subtotal position. Click on the little green triangle in
the (row/column) heading to get the subtotal properties and look at the VS
properties window. There is a "Position" property which is set to "After" by
default. You can set it to "Before", which results in the desired effect.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Teresa" <Teresa@.discussions.microsoft.com> wrote in message
news:8565A38F-17B9-40F9-BDF2-499E73A3FC85@.microsoft.com...
> Is there a way to re-position the subtotal in a matrix report such that
> the
> subtotal is displayed at the beginning of the report instead of at the
> end.
> Currently:
> Q1 10
> Q2 5
> Q3 10
> Q4 3
> Total 28
> Need:
> Total 28
> Q1 10
> Q2 5
> Q3 10
> Q4 3
> Thanks!
>

No comments:

Post a Comment