switch row to column

[alec1982]

hi,

is there anyway to switch row to columns on presentation layer straight table or pivot table? I know i can do that through the script and generic load but the issue is that the source comes from two tables..

Let me know your thoughts

Best,

Alec

[sunny_talwar]

There is an option to use 'Horizontal' for straight table on the presentation tab and for pivot table you just need to drag and drop to move dimensions and expressions around

[alec1982]

Hi Sunny,

Thank you for the information. I was aware of this solution but for some reason it no longer works for me..

Can you please send me a sample

Here is my table sample:

Sample:

Load * Inline

Customer_Type, STN_Type, Revenue

Broker,SAD,1000

Retail, QWV,200

Broker ,ARD, 1200

Broker, IUY, 890

Retail, ABC,230

];

I need the Customer_Type to show vertically, and the STN_Type to show horizontally

Thanks for all the help.

[swuehl]

Like this in a pivot table?

Customer_Type	STN_Type	ABC	ARD	IUY	QWV	SAD
Broker		-	1200	890	-	1000
Retail		230	-	-	200	-

[sunny_talwar]

alec1982 wrote:

I was aware of this solution but for some reason it no longer works for me..

Do you know what changed which caused it to not work any more? You upgraded to a different version of QV? or something else?

[Mihir_Mehta]

Can you please explain how you did that.I have exceeded my maximum document recoveries limit so I can't open your qvw file.