Is it possible to create a "total" for a non "column group" ?
Usually you add a "SubTotal" to get values in column groups summarized. Is
it possible to do something similar to a "row group column"?
Like:
DataTable
"Q1", Id1, "NonGroup", 1, "Group1", 5
"Q1", Id1, "NonGroup", 1, "Group2", 6
"Q1", Id2, "NonGroup", 1, "Group1", 7
"Q1", Id2, "NonGroup", 2, "Group2", 8
"Q1", Id2, "NonGroup", 2, "Group3", 9
Matrix
"Group1" "Group2" "Group3"
"Q1", 3 (1+2), 12 (5+7), 14 (6+8), 9You can try to right click on your row group and choose Subtotal on this
one.
Kaisa M. Lindahl Lervik
"Maran" <Maran@.discussions.microsoft.com> wrote in message
news:7AA486D8-CB21-43D3-84E5-2AC99AED3801@.microsoft.com...
> Is it possible to create a "total" for a non "column group" ?
> Usually you add a "SubTotal" to get values in column groups summarized. Is
> it possible to do something similar to a "row group column"?
> Like:
> DataTable
> "Q1", Id1, "NonGroup", 1, "Group1", 5
> "Q1", Id1, "NonGroup", 1, "Group2", 6
> "Q1", Id2, "NonGroup", 1, "Group1", 7
> "Q1", Id2, "NonGroup", 2, "Group2", 8
> "Q1", Id2, "NonGroup", 2, "Group3", 9
> Matrix
> "Group1" "Group2" "Group3"
> "Q1", 3 (1+2), 12 (5+7), 14 (6+8), 9
>|||Thank you for your response Kaisa.
I think I need to clearify my wished result, though.
If I do like suggested I get the total of all rows, 7. I like the result to
be 3, the total of the unique rows.
It might be a combination of grouping and "total".
Any suggestion welcome.
Martin Bring (Sogeti AB)
***********************
"Kaisa M. Lindahl Lervik" wrote:
> You can try to right click on your row group and choose Subtotal on this
> one.
> Kaisa M. Lindahl Lervik
> "Maran" <Maran@.discussions.microsoft.com> wrote in message
> news:7AA486D8-CB21-43D3-84E5-2AC99AED3801@.microsoft.com...
> > Is it possible to create a "total" for a non "column group" ?
> >
> > Usually you add a "SubTotal" to get values in column groups summarized. Is
> > it possible to do something similar to a "row group column"?
> >
> > Like:
> > DataTable
> > "Q1", Id1, "NonGroup", 1, "Group1", 5
> > "Q1", Id1, "NonGroup", 1, "Group2", 6
> > "Q1", Id2, "NonGroup", 1, "Group1", 7
> > "Q1", Id2, "NonGroup", 2, "Group2", 8
> > "Q1", Id2, "NonGroup", 2, "Group3", 9
> >
> > Matrix
> > "Group1" "Group2" "Group3"
> > "Q1", 3 (1+2), 12 (5+7), 14 (6+8), 9
> >
>
>|||Just a question:
The third row in your list, is that supposed to be Id1 or Id2?
Have you looked at the InScope function? This can be used to set the scope
of the sum function, so that you can choose what group to sum in your
subtotal.
You might also want to look at the RunningValue function, with SUM and the
correct group as scope.
Kaisa M. Lindahl Lervik
"Maran" <Maran@.discussions.microsoft.com> wrote in message
news:082DE84D-0126-4892-8306-4676D390DE9A@.microsoft.com...
> Thank you for your response Kaisa.
> I think I need to clearify my wished result, though.
> If I do like suggested I get the total of all rows, 7. I like the result
> to
> be 3, the total of the unique rows.
> It might be a combination of grouping and "total".
> Any suggestion welcome.
> Martin Bring (Sogeti AB)
> ***********************
> "Kaisa M. Lindahl Lervik" wrote:
>> You can try to right click on your row group and choose Subtotal on this
>> one.
>> Kaisa M. Lindahl Lervik
>> "Maran" <Maran@.discussions.microsoft.com> wrote in message
>> news:7AA486D8-CB21-43D3-84E5-2AC99AED3801@.microsoft.com...
>> > Is it possible to create a "total" for a non "column group" ?
>> >
>> > Usually you add a "SubTotal" to get values in column groups summarized.
>> > Is
>> > it possible to do something similar to a "row group column"?
>> >
>> > Like:
>> > DataTable
>> > "Q1", Id1, "NonGroup", 1, "Group1", 5
>> > "Q1", Id1, "NonGroup", 1, "Group2", 6
>> > "Q1", Id2, "NonGroup", 1, "Group1", 7
>> > "Q1", Id2, "NonGroup", 2, "Group2", 8
>> > "Q1", Id2, "NonGroup", 2, "Group3", 9
>> >
>> > Matrix
>> > "Group1" "Group2" "Group3"
>> > "Q1", 3 (1+2), 12 (5+7), 14 (6+8), 9
>> >
>>
No comments:
Post a Comment