Add Dimension in script

Wed, 25 Jul 2012 15:03:31 GMT

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.

*CpPW**	*PpPW**	*CpkPW**	*PpkPW**	*CpCT**	*PpCT**	*CpkCT**	*PpkCT**
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

Re: Add Dimension in script

Wed, 25 Jul 2012 15:24:35 GMT

Hi,

Enclosed doc demonstrates use of crossload for your problem.

Kiran.

shree909 — Wed, 25 Jul 2012 16:27:18 GMT

Should Brand=pw+CT ??

Thu, 26 Jul 2012 15:21:17 GMT

Hi,

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

Thanks & Regards,

Venkat