Matrix or Table

Good afternoon!
I have the following problem:
There is a table with following structure: PersonID, PersonName,
Field1. Filed1 is enum type with values (A1, A2, A3, B1,B2,B3, ...,
Z1,Z2,Z3).
I need the following table:
PersonID|PersonName|A1| A2|A3|(A1 + A2 + A3)|(A1+A2+A3)/Total | ... |
Z1|Z2|Z3| Z1 + Z2 + Z3|(Z1+Z2+Z3)/Total|Total
Is Table is the only solution (and I really need to fill each cell
with details) or it cone be done by means of Matrix
Thank you,you can use either, but Matrix is dynamic - table is static
If there will always be a fixed number of columns, then you can use table,
but in your example, i'd go the matrix approach.
<mnemets@.gmail.com> wrote in message
news:1170333996.383084.308920@.j27g2000cwj.googlegroups.com...
> Good afternoon!
> I have the following problem:
> There is a table with following structure: PersonID, PersonName,
> Field1. Filed1 is enum type with values (A1, A2, A3, B1,B2,B3, ...,
> Z1,Z2,Z3).
> I need the following table:
> PersonID|PersonName|A1| A2|A3|(A1 + A2 + A3)|(A1+A2+A3)/Total | ... |
> Z1|Z2|Z3| Z1 + Z2 + Z3|(Z1+Z2+Z3)/Total|Total
> Is Table is the only solution (and I really need to fill each cell
> with details) or it cone be done by means of Matrix
> Thank you,
>|||On 1 æÅ×., 18:46, "Immy" <therealasianb...@.hotmail.com> wrote:
> you can use either, butMatrixis dynamic -tableis static
> If there will always be a fixed number of columns, then you can use table,
> but in your example, i'd go thematrixapproach.
Thank you for reply.
Bur really I can't do it by matrix. Which column groups should I use,
and how can I do it ?
Thank you,|||To be clear "I can't do it by matrix" means "I don't know how to do
it by matrix"|||It means 26 * 3 + 2 = 80 columns in your table is it ok that you can have
this much, you cannot read and you need to scroll or you need all alphabets
in one row each.
Amarnath
"mnemets@.gmail.com" wrote:
> Good afternoon!
> I have the following problem:
> There is a table with following structure: PersonID, PersonName,
> Field1. Filed1 is enum type with values (A1, A2, A3, B1,B2,B3, ...,
> Z1,Z2,Z3).
> I need the following table:
> PersonID|PersonName|A1| A2|A3|(A1 + A2 + A3)|(A1+A2+A3)/Total | ... |
> Z1|Z2|Z3| Z1 + Z2 + Z3|(Z1+Z2+Z3)/Total|Total
> Is Table is the only solution (and I really need to fill each cell
> with details) or it cone be done by means of Matrix
> Thank you,
>|||Actually I am talking about 3 groups (A,B,C). In a future the nuber of
these group can be changed (not more than 5!). So it means 3*4 (three
values in a group and subtotal for the group) + 1 = 13. Maximum is 5*4
+ 1 = 21. Not so bad.
But the real problem is that I have no ideas how such matrix can be
done.
Thank you