Need to drill down

[#1]

Header 1	2013	2012
A	XXXX	XXXX
B	XXXX	XXXX
C	XXXX	XXXX
D	XXXX	XXXX

A,B,C,D are my expression

year is my dimension

now     A=X+Y

          B=P+Q+R

          C=C

          D=S+T+U

now my table should look like:

Header 1	Header 2	2013	2012
A	X	XXXX	XXXX
	Y	XXXX	XXXX
B	P	XXX	XXXX
	Q	XXX	XXXX
	R	XXX	XXXX

[#2]

Amrit,

Not sure from your question, but pivot table should suffice.

richard

[#3]

the First table is what i have and the second table is what i want

[#4]

Amrit,

If I can make an assumption based on your question. A and B could be countrys and X,Y,P,Q,R could be regions,  of it could be regions and Salesman.

I have attached an example.

If this does not help, please explain in a little more detail

Richard