how to total a column in a matrix?

How do you total a column in a matrix? It seems like it should be simple, but I am not getting anywhere.
- Here is some of my matrix as seen in Layout view. The Total column shown was created when I added a subtotal to the group Fields!MonthName.Value.
=Fields!MonthName.Value Total
Travel =Sum(Fields!Travel.Value)
Supplies =Sum(Fields!Supplies.Value)
Services =Sum(Fields!Services.Value)
- Here it is in Preview:
Jan Feb Total
Travel 100 200 300
Supplies 200 300 500
Services 100 200 300
- Here is what I WANT, notice column totals:
Jan Feb Total
Travel 100 200 300
Supplies 200 300 500
Services 100 200 300
Month Totals 400 700 1100
Thanks!can you create this formula:
=Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value) +
Sum(Fields!Services.Value)
If you have 1 value by column, then its an easy solution.
=Fields!MonthName.Value Total
Travel =Sum(Fields!Travel.Value)
Supplies =Sum(Fields!Supplies.Value)
Services =Sum(Fields!Services.Value)
Month total s =Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value) +
Sum(Fields!Services.Value)
"jacobryce" <jacobryce@.discussions.microsoft.com> a écrit dans le message de
news:4CD61168-A0DD-43CA-AE53-A6429D9CD63C@.microsoft.com...
> How do you total a column in a matrix? It seems like it should be simple,
but I am not getting anywhere.
> - Here is some of my matrix as seen in Layout view. The Total column
shown was created when I added a subtotal to the group
Fields!MonthName.Value.
> =Fields!MonthName.Value Total
> Travel =Sum(Fields!Travel.Value)
> Supplies =Sum(Fields!Supplies.Value)
> Services =Sum(Fields!Services.Value)
> - Here it is in Preview:
> Jan Feb Total
> Travel 100 200 300
> Supplies 200 300 500
> Services 100 200 300
> - Here is what I WANT, notice column totals:
> Jan Feb Total
> Travel 100 200 300
> Supplies 200 300 500
> Services 100 200 300
> Month Totals 400 700 1100
> Thanks!|||Yes that works, but I just thought there would be a more 'automatic' way, like something you would do in Excel. Thanks, though.
"Jéjé" wrote:
> can you create this formula:
> =Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value) +
> Sum(Fields!Services.Value)
> If you have 1 value by column, then its an easy solution.
> =Fields!MonthName.Value Total
> Travel =Sum(Fields!Travel.Value)
> Supplies =Sum(Fields!Supplies.Value)
> Services =Sum(Fields!Services.Value)
> Month total s =Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value) +
> Sum(Fields!Services.Value)
>
> "jacobryce" <jacobryce@.discussions.microsoft.com> a écrit dans le message de
> news:4CD61168-A0DD-43CA-AE53-A6429D9CD63C@.microsoft.com...
> > How do you total a column in a matrix? It seems like it should be simple,
> but I am not getting anywhere.
> > - Here is some of my matrix as seen in Layout view. The Total column
> shown was created when I added a subtotal to the group
> Fields!MonthName.Value.
> >
> > =Fields!MonthName.Value Total
> > Travel =Sum(Fields!Travel.Value)
> > Supplies =Sum(Fields!Supplies.Value)
> > Services =Sum(Fields!Services.Value)
> >
> > - Here it is in Preview:
> > Jan Feb Total
> > Travel 100 200 300
> > Supplies 200 300 500
> > Services 100 200 300
> >
> > - Here is what I WANT, notice column totals:
> > Jan Feb Total
> > Travel 100 200 300
> > Supplies 200 300 500
> > Services 100 200 300
> >
> > Month Totals 400 700 1100
> >
> > Thanks!
>
>|||So you have 3 static rows and no row groups? You could probably add a row
group with an expression =1 and then do a grand total.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jacobryce" <jacobryce@.discussions.microsoft.com> wrote in message
news:773526EC-6041-4EFA-ABC3-F8193E88EB04@.microsoft.com...
> Yes that works, but I just thought there would be a more 'automatic' way,
> like something you would do in Excel. Thanks, though.
> "Jéjé" wrote:
>> can you create this formula:
>> =Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value) +
>> Sum(Fields!Services.Value)
>> If you have 1 value by column, then its an easy solution.
>> =Fields!MonthName.Value Total
>> Travel =Sum(Fields!Travel.Value)
>> Supplies =Sum(Fields!Supplies.Value)
>> Services =Sum(Fields!Services.Value)
>> Month total s =Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value) +
>> Sum(Fields!Services.Value)
>>
>> "jacobryce" <jacobryce@.discussions.microsoft.com> a écrit dans le message
>> de
>> news:4CD61168-A0DD-43CA-AE53-A6429D9CD63C@.microsoft.com...
>> > How do you total a column in a matrix? It seems like it should be
>> > simple,
>> but I am not getting anywhere.
>> > - Here is some of my matrix as seen in Layout view. The Total column
>> shown was created when I added a subtotal to the group
>> Fields!MonthName.Value.
>> >
>> > =Fields!MonthName.Value Total
>> > Travel =Sum(Fields!Travel.Value)
>> > Supplies =Sum(Fields!Supplies.Value)
>> > Services =Sum(Fields!Services.Value)
>> >
>> > - Here it is in Preview:
>> > Jan Feb Total
>> > Travel 100 200 300
>> > Supplies 200 300 500
>> > Services 100 200 300
>> >
>> > - Here is what I WANT, notice column totals:
>> > Jan Feb Total
>> > Travel 100 200 300
>> > Supplies 200 300 500
>> > Services 100 200 300
>> >
>> > Month Totals 400 700 1100
>> >
>> > Thanks!
>>|||interesting idea.
I'll test it.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> a écrit dans le
message de news:ekXD0nmXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> So you have 3 static rows and no row groups? You could probably add a row
> group with an expression =1 and then do a grand total.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "jacobryce" <jacobryce@.discussions.microsoft.com> wrote in message
> news:773526EC-6041-4EFA-ABC3-F8193E88EB04@.microsoft.com...
> > Yes that works, but I just thought there would be a more 'automatic'
way,
> > like something you would do in Excel. Thanks, though.
> >
> > "Jéjé" wrote:
> >
> >> can you create this formula:
> >> =Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value) +
> >> Sum(Fields!Services.Value)
> >>
> >> If you have 1 value by column, then its an easy solution.
> >>
> >> =Fields!MonthName.Value Total
> >> Travel =Sum(Fields!Travel.Value)
> >> Supplies =Sum(Fields!Supplies.Value)
> >> Services =Sum(Fields!Services.Value)
> >> Month total s =Sum(Fields!Travel.Value) + Sum(Fields!Supplies.Value)
+
> >> Sum(Fields!Services.Value)
> >>
> >>
> >>
> >> "jacobryce" <jacobryce@.discussions.microsoft.com> a écrit dans le
message
> >> de
> >> news:4CD61168-A0DD-43CA-AE53-A6429D9CD63C@.microsoft.com...
> >> > How do you total a column in a matrix? It seems like it should be
> >> > simple,
> >> but I am not getting anywhere.
> >> > - Here is some of my matrix as seen in Layout view. The Total column
> >> shown was created when I added a subtotal to the group
> >> Fields!MonthName.Value.
> >> >
> >> > =Fields!MonthName.Value Total
> >> > Travel =Sum(Fields!Travel.Value)
> >> > Supplies =Sum(Fields!Supplies.Value)
> >> > Services =Sum(Fields!Services.Value)
> >> >
> >> > - Here it is in Preview:
> >> > Jan Feb Total
> >> > Travel 100 200 300
> >> > Supplies 200 300 500
> >> > Services 100 200 300
> >> >
> >> > - Here is what I WANT, notice column totals:
> >> > Jan Feb Total
> >> > Travel 100 200 300
> >> > Supplies 200 300 500
> >> > Services 100 200 300
> >> >
> >> > Month Totals 400 700 1100
> >> >
> >> > Thanks!
> >>
> >>
> >>
>sql