Matrix subtotal on some (not all) columns?

Anyone know how to do this?
In my matrix, some of the columns are money, other are percentages.
I want to show subtotals for the money, but will need to manually calculate
(using expressions) the percentage totals.
I only seem to be able to switch subtotal on for the whole thing (right
click subtotal)
Is there a way of having a row underneath perhaps or changing how the
subtotal works?I ended up using a table not a matrix and adding a group
then in the table or group footer you can put a SUM function
which one you choose will depend upon the structure of your data
"adolf garlic" wrote:
> Anyone know how to do this?
> In my matrix, some of the columns are money, other are percentages.
> I want to show subtotals for the money, but will need to manually calculate
> (using expressions) the percentage totals.
> I only seem to be able to switch subtotal on for the whole thing (right
> click subtotal)
> Is there a way of having a row underneath perhaps or changing how the
> subtotal works?|||How do you selectively display columns using the subtotal: especially with
calculating percentages.
I also have this problem, i have been searching this newsgroup to find a
similar question with answers, but i guess no one knows the anwser to this
one...
I am loathe to use a table instead of a Matrix, especially since, i am going
to be displaying all the days in any particular month...
I'll just have to go the table route also.
Some one please help!!!!!
Bibo
"adolf garlic" wrote:
> I ended up using a table not a matrix and adding a group
> then in the table or group footer you can put a SUM function
> which one you choose will depend upon the structure of your data
> "adolf garlic" wrote:
> > Anyone know how to do this?
> >
> > In my matrix, some of the columns are money, other are percentages.
> > I want to show subtotals for the money, but will need to manually calculate
> > (using expressions) the percentage totals.
> >
> > I only seem to be able to switch subtotal on for the whole thing (right
> > click subtotal)
> > Is there a way of having a row underneath perhaps or changing how the
> > subtotal works?|||I have similiar reports, and sorted my issues with custom calculated
sub-totals by re-thinking my data sourcing, and adding a field called
part-total to the datasource which will be a percentage of the total for
that group.
so: a group with 4 members will have part-total = 0.25 for each field.
On the Report Field you use an expression that says iif(part-total=1
...... to decide whether the is the total columns.
Give me more detail on your question and I can give you a more descriptive
solution.
From experience I could comment that for complicated reports, its worth
re-thining your data-sourcing.
I can confidently say, It shouldnt be a problem.
Marcell
"bibo" <bibo@.discussions.microsoft.com> wrote in message
news:8DD0DABB-FCBD-4506-929E-255F8DA232D1@.microsoft.com...
> How do you selectively display columns using the subtotal: especially with
> calculating percentages.
> I also have this problem, i have been searching this newsgroup to find a
> similar question with answers, but i guess no one knows the anwser to this
> one...
> I am loathe to use a table instead of a Matrix, especially since, i am
> going
> to be displaying all the days in any particular month...
> I'll just have to go the table route also.
> Some one please help!!!!!
> Bibo
> "adolf garlic" wrote:
>> I ended up using a table not a matrix and adding a group
>> then in the table or group footer you can put a SUM function
>> which one you choose will depend upon the structure of your data
>> "adolf garlic" wrote:
>> > Anyone know how to do this?
>> >
>> > In my matrix, some of the columns are money, other are percentages.
>> > I want to show subtotals for the money, but will need to manually
>> > calculate
>> > (using expressions) the percentage totals.
>> >
>> > I only seem to be able to switch subtotal on for the whole thing (right
>> > click subtotal)
>> > Is there a way of having a row underneath perhaps or changing how the
>> > subtotal works?