However I *don't* want them to provide navigation if they're in a subtotal
row or column. I can't figure out what to call in order to determine
whether the cell is a subtotal or not.
Any ideas?This is a multi-part message in MIME format.
--=_NextPart_000_0049_01C625AB.01FC8700
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Try playing around with this formula:
=3Diif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", ="In Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of =ColumnGroup1", "In Subtotal of entire matrix"))
Paste it into your usual matrix cell, and change RowGroup1 to whatever =your row group is called etc.
Kaisa M: Lindahl
"Greg S" <gregslistacct@.hotmail.com> wrote in message =news:ecBRlY7IGHA.1180@.TK2MSFTNGP09.phx.gbl...
>I have a matrix where the detail cells are set to navigate to a =subreport. > However I *don't* want them to provide navigation if they're in a =subtotal > row or column. I can't figure out what to call in order to determine > whether the cell is a subtotal or not.
> > Any ideas?
> >
--=_NextPart_000_0049_01C625AB.01FC8700
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Try playing around with this formula:
=3Diif(InScope("ColumnGroup1"), =iif(InScope("RowGroup1"), "In Cell", "In Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In =Subtotal of ColumnGroup1", "In Subtotal of entire matrix"))
Paste it into your usual matrix cell, and =change RowGroup1 to whatever your row group is called etc.
Kaisa M: Lindahl
"Greg S"
--=_NextPart_000_0049_01C625AB.01FC8700--|||This worked perfectly! Thanks.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:eWe1hKaJGHA.1832@.TK2MSFTNGP11.phx.gbl...
Try playing around with this formula:
=iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In
Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of
ColumnGroup1", "In Subtotal of entire matrix"))
Paste it into your usual matrix cell, and change RowGroup1 to whatever your
row group is called etc.
Kaisa M: Lindahl
"Greg S" <gregslistacct@.hotmail.com> wrote in message
news:ecBRlY7IGHA.1180@.TK2MSFTNGP09.phx.gbl...
>I have a matrix where the detail cells are set to navigate to a subreport.
> However I *don't* want them to provide navigation if they're in a subtotal
> row or column. I can't figure out what to call in order to determine
> whether the cell is a subtotal or not.
> Any ideas?
>|||I am not familiar with the InScope function. You did not really use all
those words did you? For instance "in Subtotal of entire matrix" ' or did
you substitute names for your matrix in there. Like I said ... I am not
familiar with that function and I am trying to learn how to use it. This
seems like a very good example and I want to understand it correctly. Thanks.
"Greg S" wrote:
> This worked perfectly! Thanks.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:eWe1hKaJGHA.1832@.TK2MSFTNGP11.phx.gbl...
> Try playing around with this formula:
> =iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In
> Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of
> ColumnGroup1", "In Subtotal of entire matrix"))
> Paste it into your usual matrix cell, and change RowGroup1 to whatever your
> row group is called etc.
> Kaisa M: Lindahl
>
> "Greg S" <gregslistacct@.hotmail.com> wrote in message
> news:ecBRlY7IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> >I have a matrix where the detail cells are set to navigate to a subreport.
> > However I *don't* want them to provide navigation if they're in a subtotal
> > row or column. I can't figure out what to call in order to determine
> > whether the cell is a subtotal or not.
> >
> > Any ideas?
> >
> >
>|||The InScope function relates to the name of the scope, which can be a row
group name, a column group name, a matrix name or a dataset name.
If you have one ColumnGroup called thisColumnGroup, one RowGroup called
thisRowGroup and a Matrix called thisMatrix, the following code
=iif(InScope("ColumnGroup1"),
iif(InScope("RowGroup1"), "In Cell", "In Subtotal of RowGroup1"),
iif(InScope("RowGroup1"), "In Subtotal of ColumnGroup1", "In Subtotal of
entire matrix"))
would be translated to
=IIF(Inscope("thisColumnGroup"),
IIF(inScope("thisRowGroup"), "This is the text that will show up in cells in
thisColumnGroup", "This is the text that will show up in the subtotal of
thisRowGroup"),
IIF(InScope("thisRowGroup"), "This is the text that will show up in the
subtotal of thisColumnGroup",
"This is the text that shows up in the intersection between your row and
column groups"))
Create a matrix with a row group and a column group, change the names of
thisColumnGroup and thisRowGroup with the names of your groups, and put the
statement above in a detail cell, and see what shows up. :)
A more normal statement would be
=IIF(Inscope("thisColumnGroup"),
IIF(inScope("thisRowGroup"), Fields!Name.Value,
um(Fields!ColumnName.Value ),
IIF(InScope("thisRowGroup"), sum(Fields!ColumnName2.Value ,
"x"))
But the best thing is to try it out, the scopes are a bit abstract, it's
easier to understand if you try playing with it. (At least that's what I do.
:) )
Kaisa M. Lindahl Lervik
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:1901C919-A4EA-48D0-B8FE-56F059A8660F@.microsoft.com...
>I am not familiar with the InScope function. You did not really use all
> those words did you? For instance "in Subtotal of entire matrix" ' or
> did
> you substitute names for your matrix in there. Like I said ... I am not
> familiar with that function and I am trying to learn how to use it. This
> seems like a very good example and I want to understand it correctly.
> Thanks.
> "Greg S" wrote:
>> This worked perfectly! Thanks.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
>> news:eWe1hKaJGHA.1832@.TK2MSFTNGP11.phx.gbl...
>> Try playing around with this formula:
>> =iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In
>> Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of
>> ColumnGroup1", "In Subtotal of entire matrix"))
>> Paste it into your usual matrix cell, and change RowGroup1 to whatever
>> your
>> row group is called etc.
>> Kaisa M: Lindahl
>>
>> "Greg S" <gregslistacct@.hotmail.com> wrote in message
>> news:ecBRlY7IGHA.1180@.TK2MSFTNGP09.phx.gbl...
>> >I have a matrix where the detail cells are set to navigate to a
>> >subreport.
>> > However I *don't* want them to provide navigation if they're in a
>> > subtotal
>> > row or column. I can't figure out what to call in order to determine
>> > whether the cell is a subtotal or not.
>> >
>> > Any ideas?
>> >
>> >
>>|||Thanks for the great explanation Kaisa ... I will try playing around with it
using this example. I appreciate your help!
"Kaisa M. Lindahl Lervik" wrote:
> The InScope function relates to the name of the scope, which can be a row
> group name, a column group name, a matrix name or a dataset name.
> If you have one ColumnGroup called thisColumnGroup, one RowGroup called
> thisRowGroup and a Matrix called thisMatrix, the following code
> =iif(InScope("ColumnGroup1"),
> iif(InScope("RowGroup1"), "In Cell", "In Subtotal of RowGroup1"),
> iif(InScope("RowGroup1"), "In Subtotal of ColumnGroup1", "In Subtotal of
> entire matrix"))
> would be translated to
>
> =IIF(Inscope("thisColumnGroup"),
> IIF(inScope("thisRowGroup"), "This is the text that will show up in cells in
> thisColumnGroup", "This is the text that will show up in the subtotal of
> thisRowGroup"),
> IIF(InScope("thisRowGroup"), "This is the text that will show up in the
> subtotal of thisColumnGroup",
> "This is the text that shows up in the intersection between your row and
> column groups"))
> Create a matrix with a row group and a column group, change the names of
> thisColumnGroup and thisRowGroup with the names of your groups, and put the
> statement above in a detail cell, and see what shows up. :)
> A more normal statement would be
> =IIF(Inscope("thisColumnGroup"),
> IIF(inScope("thisRowGroup"), Fields!Name.Value,
> um(Fields!ColumnName.Value ),
> IIF(InScope("thisRowGroup"), sum(Fields!ColumnName2.Value ,
> "x"))
> But the best thing is to try it out, the scopes are a bit abstract, it's
> easier to understand if you try playing with it. (At least that's what I do.
> :) )
> Kaisa M. Lindahl Lervik
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:1901C919-A4EA-48D0-B8FE-56F059A8660F@.microsoft.com...
> >I am not familiar with the InScope function. You did not really use all
> > those words did you? For instance "in Subtotal of entire matrix" ' or
> > did
> > you substitute names for your matrix in there. Like I said ... I am not
> > familiar with that function and I am trying to learn how to use it. This
> > seems like a very good example and I want to understand it correctly.
> > Thanks.
> >
> > "Greg S" wrote:
> >
> >> This worked perfectly! Thanks.
> >>
> >>
> >> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> >> news:eWe1hKaJGHA.1832@.TK2MSFTNGP11.phx.gbl...
> >> Try playing around with this formula:
> >> =iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In
> >> Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of
> >> ColumnGroup1", "In Subtotal of entire matrix"))
> >>
> >> Paste it into your usual matrix cell, and change RowGroup1 to whatever
> >> your
> >> row group is called etc.
> >>
> >> Kaisa M: Lindahl
> >>
> >>
> >> "Greg S" <gregslistacct@.hotmail.com> wrote in message
> >> news:ecBRlY7IGHA.1180@.TK2MSFTNGP09.phx.gbl...
> >> >I have a matrix where the detail cells are set to navigate to a
> >> >subreport.
> >> > However I *don't* want them to provide navigation if they're in a
> >> > subtotal
> >> > row or column. I can't figure out what to call in order to determine
> >> > whether the cell is a subtotal or not.
> >> >
> >> > Any ideas?
> >> >
> >> >
> >>
> >>
>
>sql
No comments:
Post a Comment