Matrix - Show Percentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathy - 05 Jan 2006 16:45 GMT

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

Reply to this Message

Kaisa M. Lindahl - 05 Jan 2006 20:33 GMT

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

> Hi,
>
[quoted text clipped - 19 lines]
>
> Any help would be greatly appreciated!!

Reply to this Message

dt1820@gmail.com - 06 Jan 2006 16:33 GMT

in the totals line take the total/shipped this will give the percent of
the total. if that is what you are looking for

Reply to this Message

Kathy - 06 Jan 2006 20:05 GMT

I was trying to figure out how to have the matrix show that detail. The
inscope function was my saving... Thanks!

> in the totals line take the total/shipped this will give the percent of
> the total. if that is what you are looking for

Reply to this Message

MJT - 26 Jan 2006 19:19 GMT

How does InScope work? where did you put it? I am not familiar with that
but I will need to be shortly.

> I was trying to figure out how to have the matrix show that detail. The
> inscope function was my saving... Thanks!
>
> > in the totals line take the total/shipped this will give the percent of
> > the total. if that is what you are looking for

Reply to this Message

Todd Bannar - 31 Jan 2006 20:55 GMT

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

> What will the total percent be based on? Or do you just want something else
> than "n/a"?
[quoted text clipped - 31 lines]
> >
> > Any help would be greatly appreciated!!

Reply to this Message