Add Dimension in script

[#1]

Hi,

In my table contains fields like below : In my table contains  8 columns, in this 4 columns belongs to PW brand and 4 belongs to CT brand.

Cp*PW	Pp*PW	Cpk*PW	Ppk*PW	Cp*CT	Pp*CT	Cpk*CT	Ppk*CT
1.1	1.23	2.45	4.5	1.5	1.45	4.8	4.9

Now can i know how to create another field that should  contains like "Brand" with data of PW, CT. It should be like below structure in Pivot table  :

Brand  

PW       Cp      1.1

             Pp       1.23

             Cpk     2.45

             Ppk     4.5

CT        Cp       1.5

             Pp       1.45

             Cpk     4.8

             Ppk     4.9

How can i do it ?

Greatly appreciated for your ideas on this.

Thanks in advance.

Regards,

Venkat

[#2 · Accepted solution]

Hi,

Enclosed doc demonstrates use of crossload for your problem.

Kiran.

[shree909]

Should  Brand=pw+CT ??

[#4]

Hi,

Thanks a lot. That's what i'm looking.

Thanks & Regards,

Venkat