Matrix Subtotals

I have created a matrix and I am trying to add a percentage subtotal on the
following. I have this Fiscal Year (FY) and Last Fiscal Year (LFY) data. Then
I added in a subtotal by right clicking on the column group for Male/Female.
Know I need to add and additional field that calculates the Total % .
M F Total Total %
Age FY LFY FY LFY FY LFY FY LFY
0 10 5 1 5 11 10 .33 .46
1-4 4 2 12 3 16 5 .47 .23
5-9 3 1 4 6 7 7 .21 .32
Total 17 8 17 14 34 22This is a multi-part message in MIME format.
--=_NextPart_000_003D_01C61F7D.57B99130
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
You'll probably need to check for scope in your cell expression, to make =the right calculation based on "where" you are in your matrix.
Use the following guideline:
=3DIif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", ="In Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of =ColumnGroup1", "In Subtotal of entire matrix"))
Then, to calculate the percent, in the right scope, use this:
Fields!Name.Value / First(Fields!Amount.Value, "MatrixColumnGroupName") =- assuming that your first row is a total.
If it's not, you might be able to use SUM if you add the Matrix column =group name =3D Fields!Name.Value / SUM(Fields!Amount.Value, ="MatrixColumnGroupName")
Kaisa M. Lindahl
"Asim" <Asim@.discussions.microsoft.com> wrote in message =news:2BAED4A1-4E68-4B13-A0E0-A76A8B8D9BC3@.microsoft.com...
>I have created a matrix and I am trying to add a percentage subtotal on =the > following. I have this Fiscal Year (FY) and Last Fiscal Year (LFY) =data. Then > I added in a subtotal by right clicking on the column group for =Male/Female. > Know I need to add and additional field that calculates the Total % .
> > M F Total =Total %
> Age FY LFY FY LFY FY LFY FY LFY
> 0 10 5 1 5 11 10 .33 = .46
> 1-4 4 2 12 3 16 5 .47 = .23
> 5-9 3 1 4 6 7 7 .21 = .32
> Total 17 8 17 14 34 22
--=_NextPart_000_003D_01C61F7D.57B99130
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

You'll probably need to check for scope in your cell =expression, to make the right calculation based on "where" you are in =your matrix.
Use the following guideline:
=3DIif(InScope("ColumnGroup1"), =iif(InScope("RowGroup1"), "In Cell", "In Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In =Subtotal of ColumnGroup1", "In Subtotal of entire matrix"))
Then, to calculate the percent, in the right scope, =use this:
Fields!Name.Value / First(Fields!Amount.Value, ="MatrixColumnGroupName") - assuming that your first row is a total.
If it's not, you might be able to use SUM if you add =the Matrix column group name =3D Fields!Name.Value / =SUM(Fields!Amount.Value, "MatrixColumnGroupName")
Kaisa M. Lindahl
"Asim" =wrote in message news:2BAED4A1-4E68-4B13-A0E0-A76A8B8D9BC3@.microsoft.com...>I have created a matrix and =I am trying to add a percentage subtotal on the > following. I have this =Fiscal Year (FY) and Last Fiscal Year (LFY) data. Then > I added in a =subtotal by right clicking on the column group for Male/Female. > Know =I need to add and additional field that calculates the Total % .> >  =; M F = Total Total %> Age &nbs=p; FY LFY FY LFY FY LFY FY =LFY> 0 = 10 5 =1 5 11 10 .33 =.46> 1-4 &nbs=p; 4 2 12 3 =16 5 =.47 .23> 5-9 &nbs=p; 3 1 =4 6 7 =7 .21 .32> Total &n=bsp; 17 8 =17 14 34 22

---

--=_NextPart_000_003D_01C61F7D.57B99130--|||Kaisa,
You seem to understand this InScope function so well and yet I take your
suggestion as you say "you have to check for scope in your cell expression".
The cell expression only *allows* one expression. In my detail cell I have
something like Sum(Fields!CriticalCount.value) and I can see how to put that
into the InScope but I want to do something else if I am in the subtotal and
I have questions about that. You are getting close to providing the answer
here when you say "then to calculate the percent in the right scope..." but
*where* would you put this calculation in the *one* cell expression that is
there? I have messed with this for a long time and almost got it working
with ONE column and ONE row ... but still couldnt figure out how to create a
subtotal expression different ( I tried using some thing like
SUM(ReportItems!tbCritCount.value) for the subtotal expression and of course
got errors on the aggregate and using ReportItems! ) So how can I reference
the values I want? lets say I want to check the max value in a column at the
subtotal level? OK ... if I cant do that ... then lets say I want to SUM the
values of an expression that I have in the detail cell of the column. I am
just not getting this and I am really really trying to ... :-(
"Kaisa M. Lindahl" wrote:
> You'll probably need to check for scope in your cell expression, to make the right calculation based on "where" you are in your matrix.
> Use the following guideline:
> =Iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of ColumnGroup1", "In Subtotal of entire matrix"))
> Then, to calculate the percent, in the right scope, use this:
> Fields!Name.Value / First(Fields!Amount.Value, "MatrixColumnGroupName") - assuming that your
> first row is a total.
> If it's not, you might be able to use SUM if you add the Matrix column group
> name = Fields!Name.Value / SUM(Fields!Amount.Value, "MatrixColumnGroupName")
> Kaisa M. Lindahl
> "Asim" <Asim@.discussions.microsoft.com> wrote in message news:2BAED4A1-4E68-4B13-A0E0-A76A8B8D9BC3@.microsoft.com...
> >I have created a matrix and I am trying to add a percentage subtotal on the
> > following. I have this Fiscal Year (FY) and Last Fiscal Year (LFY) data. Then
> > I added in a subtotal by right clicking on the column group for Male/Female.
> > Know I need to add and additional field that calculates the Total % .
> >
> > M F Total Total %
> > Age FY LFY FY LFY FY LFY FY LFY
> > 0 10 5 1 5 11 10 .33 .46
> > 1-4 4 2 12 3 16 5 .47 .23
> > 5-9 3 1 4 6 7 7 .21 .32
> > Total 17 8 17 14 34 22sql

Matrix SubTotal Percentage

I have a matrix with dynamic rows and columns. I got the totals for the
Rows and Columns by
right clicking the groups and selecting the SubTotal option.
Can I display the totals in percentage.
[Column1] [Columns2] [ Total] [C-Percent]
[Row1] 1 2 3 50%
[Row2 ] 2 1 3 50%
----
[Total] 3 3 6
[R-Percent](50%) (50%) (100%)
Any help is appreciated.
Thanks
ReddyCreate a column, and set your expression to Fields!Name.Value /
First(Fields!Amount.Value, "MatrixColumnGroupName") - assuming that your
first row is a total.
If it's not, you might be able to use SUM if you add the Matrix column group
name = Fields!Name.Value / SUM(Fields!Amount.Value, "MatrixColumnGroupName")
Kaisa M. Lindahl Lervik
"reddy" <pparlapa@.gmail.com> wrote in message
news:OklmLNQVGHA.6048@.TK2MSFTNGP11.phx.gbl...
>I have a matrix with dynamic rows and columns. I got the totals for the
>Rows and Columns by
> right clicking the groups and selecting the SubTotal option.
> Can I display the totals in percentage.
> [Column1] [Columns2] [ Total] [C-Percent]
> [Row1] 1 2 3 50%
> [Row2 ] 2 1 3 50%
> ----
> [Total] 3 3 6
> [R-Percent](50%) (50%) (100%)
> Any help is appreciated.
> Thanks
> Reddy
>sql

Matrix Subtotal Format

Have several rows in a Matrix, every row has a different format (percentage,
Currently, Number). The Matrix has 3 groups (all groups not displayed below)
Average Shop1 Shop2 Shop3
Technicians 8.0 7 5 2
Efficiency 70.5% 60.0 75.2 70.1
Hours 1,000 500 2000 1000
I do an average for all columns display the average for that column on the
left side
In my development environment (Visual Studio) the average column formatting
works fine and takes the formatting of other columns in the row. After being
deployed to the reporting server and viewing through the report viewer the
formatting does not seem to work and seems to take the formatting of the
first group.
ThanksAfter hours of digging, the issue seems to be because of SP2.
http://forums.microsoft.com/MSDN/showpost.aspx?postid=2215374&siteid=1
"jeo78" wrote:
> Have several rows in a Matrix, every row has a different format (percentage,
> Currently, Number). The Matrix has 3 groups (all groups not displayed below)
> Average Shop1 Shop2 Shop3
> Technicians 8.0 7 5 2
> Efficiency 70.5% 60.0 75.2 70.1
> Hours 1,000 500 2000 1000
> I do an average for all columns display the average for that column on the
> left side
> In my development environment (Visual Studio) the average column formatting
> works fine and takes the formatting of other columns in the row. After being
> deployed to the reporting server and viewing through the report viewer the
> formatting does not seem to work and seems to take the formatting of the
> first group.
> Thankssql

Matrix row total

I have a count(field!orderstamp.Value) in a field and I would like to
show the percentage that number is of the whole row?
I can add a column next to it, but how do I show a percentage of a row
in a matrix?
Thanks.Assuming you have a matrix row grouping called "MatrixRowGroup", you can try
this:
=Count(Fields!orderstamp.Value) / Count(Fields!orderstamp.Value,
"MatrixRowGroup")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Geddes" <john_g@.alamode.com> wrote in message
news:OVtGb$p8EHA.2804@.TK2MSFTNGP15.phx.gbl...
> I have a count(field!orderstamp.Value) in a field and I would like to
> show the percentage that number is of the whole row?
> I can add a column next to it, but how do I show a percentage of a row
> in a matrix?
> Thanks.
>

Matrix Report - Add Pct of Total Column

How could I add a percentage of total column to a matrix that looks
like this:
Employment Status Owned Rented Total
Full-Time 10 10 20
Part Time 20 20 40
Totals 30 30 60
I want it to look like:
Employment Status Owned Rented Total Pct of Tot
Full-Time 10 10 20 33.3
Part Time 20 20 40 66.7
Totals 30 30 60 100.0
Any help would be appreciated.
Regards,
Tom OlthoffWrite your expression, format the textox using P or P2
<OTSolutions@.shaw.ca> wrote in message
news:1123180864.018293.197390@.g49g2000cwa.googlegroups.com...
> How could I add a percentage of total column to a matrix that looks
> like this:
> Employment Status Owned Rented Total
> Full-Time 10 10 20
> Part Time 20 20 40
> Totals 30 30 60
> I want it to look like:
> Employment Status Owned Rented Total Pct of Tot
> Full-Time 10 10 20 33.3
> Part Time 20 20 40 66.7
> Totals 30 30 60 100.0
> Any help would be appreciated.
> Regards,
> Tom Olthoff
>|||Ok, once I have the expression how do I add the column to the end of
the matrix? There is no Add Column when I right click the last column
on the matrix. Just Add Column Group, which does not do what I need it
to do.
Regards,
Tom

Matrix Percentage Column ( Column 2 vs Column 1)

Need help with calculating percentage column in a matrix.

2005 2006

Jan 10 15

Feb 20 25

Need to add column showing variance :

Var Var

Jan 10 15 50%

Feb 20 25 25%

Any help would be appreciated....

Hi. Did you manage to get the result.I also have the similar case. If you have solved can you plz help me out.

Matrix Percentage Column ( Column 2 vs Column 1)

Need help with calculating percentage column in a matrix.

2005 2006

Jan 10 15

Feb 20 25

Need to add column showing variance :

Var Var

Jan 10 15 50%

Feb 20 25 25%

Any help would be appreciated....

Hi. Did you manage to get the result.I also have the similar case. If you have solved can you plz help me out.

Matrix calculation for percent

How do I write expression to calculate a value to show percentage of the
subtotal value in a Matrix?
I have already tried =Fields!name.value/sum(Fields!name.value) and this
does not work
Example:
Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
like to show the percentage of the subtotal for Matrix_Row in a column next
to Matrix Col.
Matrix_Col Percent
Matrix_Row
value 1 %25
value 2 %50
value 1 %25
Total 4Create a column, and set your expression to Fields!Name.Value /
First(Fields!Amount.Value, "MatrixColumnGroupName") - assuming that your
first row is a total.
If it's not, you might be able to use SUM if you add the Matrix column group
name = Fields!Name.Value / SUM(Fields!Amount.Value, "MatrixColumnGroupName")
Kaisa M. Lindahl
"Curtis" <gilbertson.curtis@.leg.wa.gov> wrote in message
news:uB5u4igFGHA.1028@.TK2MSFTNGP11.phx.gbl...
> How do I write expression to calculate a value to show percentage of the
> subtotal value in a Matrix?
> I have already tried =Fields!name.value/sum(Fields!name.value) and this
> does not work
> Example:
> Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
> like to show the percentage of the subtotal for Matrix_Row in a column
> next
> to Matrix Col.
> Matrix_Col Percent
> Matrix_Row
> value 1 %25
> value 2 %50
> value 1 %25
>
> Total 4
>|||Thank you very much for your answer, I've been looking for a solution for
months.
"Kaisa M. Lindahl" wrote:
> Create a column, and set your expression to Fields!Name.Value /
> First(Fields!Amount.Value, "MatrixColumnGroupName") - assuming that your
> first row is a total.
> If it's not, you might be able to use SUM if you add the Matrix column group
> name = Fields!Name.Value / SUM(Fields!Amount.Value, "MatrixColumnGroupName")
> Kaisa M. Lindahl
> "Curtis" <gilbertson.curtis@.leg.wa.gov> wrote in message
> news:uB5u4igFGHA.1028@.TK2MSFTNGP11.phx.gbl...
> > How do I write expression to calculate a value to show percentage of the
> > subtotal value in a Matrix?
> >
> > I have already tried =Fields!name.value/sum(Fields!name.value) and this
> > does not work
> >
> > Example:
> > Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
> > like to show the percentage of the subtotal for Matrix_Row in a column
> > next
> > to Matrix Col.
> >
> > Matrix_Col Percent
> >
> > Matrix_Row
> >
> > value 1 %25
> >
> > value 2 %50
> >
> > value 1 %25
> >
> >
> >
> > Total 4
> >
> >
>
>

Matrix - Show Percentage

Hi,
I'm hoping that someone can help me out; I'm working under a (past-due)
deadline and cannot seem to get this to work...
I need to create a matrix that looks like this:
Shipped Pending Total %Complete
Customer A
Order Type A $100 0 $100 100%
Order Type B $150 $150 $300 50%
Order Type C $100 $300 $400 25%
Customer B
Order Type A $900 0 $900 100%
----
Totals $1250 $450 $1700 n/a
I have no problems until I get to the percentage part... how can I add it to
the subtotal?
Any help would be greatly appreciated!!What will the total percent be based on? Or do you just want something else
than "n/a"?
If you want to know if you're in the totals rows or not, you add the InScope
function. This will give you some control over what calculation happens
where in the matrix:
=iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In
Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of
ColumnGroup1", "In Subtotal of entire matrix"))
Kaisa
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:C92E5D92-DE6C-4402-B756-493E5181069A@.microsoft.com...
> Hi,
> I'm hoping that someone can help me out; I'm working under a (past-due)
> deadline and cannot seem to get this to work...
> I need to create a matrix that looks like this:
> Shipped Pending Total
> %Complete
> Customer A
> Order Type A $100 0 $100 100%
> Order Type B $150 $150 $300 50%
> Order Type C $100 $300 $400 25%
> Customer B
> Order Type A $900 0 $900 100%
> ----
> Totals $1250 $450 $1700 n/a
> I have no problems until I get to the percentage part... how can I add it
> to
> the subtotal?
> Any help would be greatly appreciated!!
>|||in the totals line take the total/shipped this will give the percent of
the total. if that is what you are looking for|||I was trying to figure out how to have the matrix show that detail. The
inscope function was my saving... Thanks!
"dt1820@.gmail.com" wrote:
> in the totals line take the total/shipped this will give the percent of
> the total. if that is what you are looking for
>|||How does InScope work? where did you put it? I am not familiar with that
but I will need to be shortly.
"Kathy" wrote:
> I was trying to figure out how to have the matrix show that detail. The
> inscope function was my saving... Thanks!
> "dt1820@.gmail.com" wrote:
> > in the totals line take the total/shipped this will give the percent of
> > the total. if that is what you are looking for
> >
> >|||Where do you put the InScope function? I need to do the following:
Cat A1 Cat B2 Total %
Order Type A 5 2 7 8.52%
(7/82)
Order Type B 10 15 25 30.48%
(25/82)
Order Type C 20 30 50 60.97%
(50/82
----
Totals 35 47 82 100%
I have everything but the % column.
Thanks
Todd Bannar
"Kaisa M. Lindahl" wrote:
> What will the total percent be based on? Or do you just want something else
> than "n/a"?
> If you want to know if you're in the totals rows or not, you add the InScope
> function. This will give you some control over what calculation happens
> where in the matrix:
> =iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In
> Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of
> ColumnGroup1", "In Subtotal of entire matrix"))
> Kaisa
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:C92E5D92-DE6C-4402-B756-493E5181069A@.microsoft.com...
> > Hi,
> >
> > I'm hoping that someone can help me out; I'm working under a (past-due)
> > deadline and cannot seem to get this to work...
> >
> > I need to create a matrix that looks like this:
> >
> > Shipped Pending Total
> > %Complete
> > Customer A
> > Order Type A $100 0 $100 100%
> > Order Type B $150 $150 $300 50%
> > Order Type C $100 $300 $400 25%
> > Customer B
> > Order Type A $900 0 $900 100%
> > ----
> > Totals $1250 $450 $1700 n/a
> >
> > I have no problems until I get to the percentage part... how can I add it
> > to
> > the subtotal?
> >
> > Any help would be greatly appreciated!!
> >
>
>

Matrix - Calculating Percentage of Two Rows

I have 2 rows in my matrix which are a result of a dataset. I'd like to
determine the percentage of the two within the subtotal row. Let's say I
have one row called "Lates" and another called "Line Items". How can I get
the subtotal column to display the result of "Lates/Line Items" instead of
the total of the two?Here is some more information - any help would be great as I need this solved
as soon as possible.
01/05 02/05 03/05 04/05 05/05
06/05
Lates 1 2 0 4
1 3
Line Items 555 458 360 675 456
789
%On Time 99.82% 99.56% 100% 99.41% 99.78% 99.62%
The %On Time row needs to be calculated like 1-(Lates/Line Items). I've
spent the last 10 hours trying to solve this problem with no success. I'm
attempting to do this within a matrix.
"yrmeyer" wrote:
> I have 2 rows in my matrix which are a result of a dataset. I'd like to
> determine the percentage of the two within the subtotal row. Let's say I
> have one row called "Lates" and another called "Line Items". How can I get
> the subtotal column to display the result of "Lates/Line Items" instead of
> the total of the two?

Matrix - Calculate percentage column

How do I write expression to calculate a value to show percentage of the
subtotal value in a Matrix? example:
Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
like to show the percentage of the subtotal for Matrix_Row in a column next
to Matrix Col.
Matrix_Col Percent
Matrix_Row
value 1 %25
value 2 %50
value 1 %25
Total 4I would try this in the third column
Field!Name.Value/ SUM(Field!Name.Value)
I'd also give this third column a percentage format
Med bouchenafa
"Curtis" <gilbertson.curtis@.leg.wa.gov> a écrit dans le message de news:
%23tJnBVXFGHA.2320@.TK2MSFTNGP11.phx.gbl...
> How do I write expression to calculate a value to show percentage of the
> subtotal value in a Matrix? example:
> Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
> like to show the percentage of the subtotal for Matrix_Row in a column
> next to Matrix Col.
>
> Matrix_Col Percent
> Matrix_Row
> value 1 %25
> value 2 %50
> value 1 %25
>
> Total 4
>|||Med, Thanks for your reply. I have tried this already and it does not work.
I tried it in the third column as well and it still does not work. Any
other ideas?
"Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
news:uuhpEWfFGHA.516@.TK2MSFTNGP15.phx.gbl...
>I would try this in the third column
> Field!Name.Value/ SUM(Field!Name.Value)
> I'd also give this third column a percentage format
> Med bouchenafa
>
> "Curtis" <gilbertson.curtis@.leg.wa.gov> a écrit dans le message de news:
> %23tJnBVXFGHA.2320@.TK2MSFTNGP11.phx.gbl...
>> How do I write expression to calculate a value to show percentage of the
>> subtotal value in a Matrix? example:
>> Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I
>> would like to show the percentage of the subtotal for Matrix_Row in a
>> column next to Matrix Col.
>>
>> Matrix_Col Percent
>> Matrix_Row
>> value 1 %25
>> value 2 %50
>> value 1 %25
>>
>> Total 4
>>
>

Matrices & Totals

I have a matrix with two levels of row grouping and one level of column
grouping. For each cell I need to show the percentage of the group subtotal.
Here's an example.
CG1 CG2 CG3
# % # % # %
RG1 RG11 50 50% 20 10% 400 20%
RG12 20 20% 80 40% 300 15%
RG13 30 30% 100 50% 1300 65%
Total 100 33% 200 40% 2000 12%
RG2 RG21 10 5% 50 17% 1000 7%
RG22 30 15% 60 20% 2000 13%
RG23 40 20% 70 23% 3000 20%
RG24 60 30% 80 27% 4000 27%
RG25 60 30% 40 13% 5000 33%
Total 200 67% 300 60% 15000 88%
Grand Total 300 100% 500 100% 17000 100%
I've stuck with formula to calculate %.
Please, help!
--
Thanks,
IDhi,
Its hard to get the total from the report .. I had the same problem. What I
did, I took the total of the each rowm from the Query itself and in the
report screen, in the % cell, I did
Fields!RG!.Value/Fields!Total.Value and put its format P2.
it was working fine with these expression.
try this...
Bismi
"exkievan" wrote:
> I have a matrix with two levels of row grouping and one level of column
> grouping. For each cell I need to show the percentage of the group subtotal.
> Here's an example.
>
> CG1 CG2 CG3
> # % # % # %
> RG1 RG11 50 50% 20 10% 400 20%
> RG12 20 20% 80 40% 300 15%
> RG13 30 30% 100 50% 1300 65%
> Total 100 33% 200 40% 2000 12%
> RG2 RG21 10 5% 50 17% 1000 7%
> RG22 30 15% 60 20% 2000 13%
> RG23 40 20% 70 23% 3000 20%
> RG24 60 30% 80 27% 4000 27%
> RG25 60 30% 40 13% 5000 33%
> Total 200 67% 300 60% 15000 88%
> Grand Total 300 100% 500 100% 17000 100%
> I've stuck with formula to calculate %.
> Please, help!
> --
> Thanks,
> ID|||Thanks, Bismi. I did it the same way. I thought there's a way to do it on the
report.
--
Thanks,
ID
"Bismi" wrote:
> hi,
> Its hard to get the total from the report .. I had the same problem. What I
> did, I took the total of the each rowm from the Query itself and in the
> report screen, in the % cell, I did
> Fields!RG!.Value/Fields!Total.Value and put its format P2.
> it was working fine with these expression.
> try this...
> Bismi
> "exkievan" wrote:
> > I have a matrix with two levels of row grouping and one level of column
> > grouping. For each cell I need to show the percentage of the group subtotal.
> >
> > Here's an example.
> >
> >
> > CG1 CG2 CG3
> > # % # % # %
> > RG1 RG11 50 50% 20 10% 400 20%
> > RG12 20 20% 80 40% 300 15%
> > RG13 30 30% 100 50% 1300 65%
> > Total 100 33% 200 40% 2000 12%
> > RG2 RG21 10 5% 50 17% 1000 7%
> > RG22 30 15% 60 20% 2000 13%
> > RG23 40 20% 70 23% 3000 20%
> > RG24 60 30% 80 27% 4000 27%
> > RG25 60 30% 40 13% 5000 33%
> > Total 200 67% 300 60% 15000 88%
> > Grand Total 300 100% 500 100% 17000 100%
> >
> > I've stuck with formula to calculate %.
> >
> > Please, help!
> > --
> > Thanks,
> >
> > ID