Did you look at the InScope function? It will allow you to distinguish
between cells in subtotals and cells in the groupings. More information on
InScope is available at:
http://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_0jmt.asp --
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Paul Allan" <paul_allan@maxqtech.com> wrote in message
news:O%23pHpENnEHA.3172@TK2MSFTNGP10.phx.gbl...
> In a matrix with multiple groups on an axis, which has sub totals, how do
> you determine in an expression where a particular data cell is?
>
> For example:
> ----------------------------------------------------------
> | -2003 | +2004
|
> Total |
> ----------------------------------------------------------
> | Q1 | Q2 | Q3 | Q4 | |
> |
> ------------------------------------------------------------------
> Item 1 | x1 | x2 | x3 | x4 | x5 |
> x6 |
> ------------------------------------------------------------------
> Item 2 | x7 | x8 | x9 | x10 | x11 |
> x12 |
> ------------------------------------------------------------------
>
> x1 = Item 1 for 2003-Q1
> x2 = Item 1 for 2003-Q2
> x3 = Item 1 for 2003-Q3
> x4 = Item 1 for 2003-Q4
> x5 = Item 1 for 2004
> x6 = Item 1 for (2003 + 2004)
> x7 = Item 2 for 2003-Q1
> x8 = Item 2 for 2003-Q2
> x9 = Item 2 for 2003-Q3
> x10 = Item 2 for 2003-Q4
> x11 = Item 2 for 2004
> x12 = Item 2 for (2003 + 2004)
>
> For instance:
> At cell position x4, how do I know that I am in group 2 (Quarters), at
cell
> position x5, how do I know that I am in group 1 (years), and at cell
> position x6, how do I know that I am in group 1 (years) sub total??????
>
>
