Data Representation

[Anonymous]

d1	d2	e1	e2	e3	e4	e5	e6	e7	e8	e9	e10
a	x	34	34	88	78	77	99	21	77	44	33
a	x	45	43	98	44	44	33	22	33	49	23
a	v	33	44	44	77	66	55	55	83	10	44
a	x	12	11	77	32	77	66	49	66	22	55
b	y	21	10	44	1	56	99	67	45	21	44
b	y	33	23	99	33	66	23	44	22	19	89
b	y	67	89	22	77	44	33	45	21	9	99

I have two dimension d1 and d2 and rest e1 to e10 as expression.

I want representation like this in a table

d1        d2                                  e5           e6            e7             e8            e9           e10

                         e1

           x            e2   

                        e3

                        e4       

a              

                       e1

          v           e2   

                       e3

                       e4       

b         y          e1

                      e2   

                      e3

                      e4       

want to understand is that possible its a  urgent requirement,

I have tried pivot table and upto third column that is e1,e2,e3,e4  but rest of e5 to e10 in normal format

i am not sure is that possible.

Anant

[MK_QSL]

Humble Request : Always try to provide sample data in excel file which would be easier to reply..

[Anonymous]

any help /suggestion guys?

[MK_QSL]

Would like to try on this but need data in excel format.... if you can provide please...

[Anonymous]

added excel.

[Anonymous]

just added excel for ref inmy orignal post.

<<pfa>>

[MK_QSL]

will try and come back to you on this..

[#8]

HI Anant Dubey,

This is not possible because. When you mean you want e1 to e4 horizontally and the rest vertically. You are trying to show e1 to e4 associated with e5 to e10 which seems to be not very logical to me.

This is only possible when e1 to e4 are some calculated dimensions. So i think you should specify exactly what these columns are to proceed.

Regards,

Shiva.

[kamalqlik]

Hi Anant,

I don't think this will be possible.

Regards,

Kamal