Friday, March 9, 2012

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!!
> >
>
>

No comments:

Post a Comment