Switching Axis..

[leocattqv]

Hi all,

I have a data structure in my load that looks something like this:

Location	buiseness	Sales Percentage
USA	widgets	25%
USA	whosits	50%
Germany	widgets	30%
Germany	whosits	15%

I need a table that looks something like this:

Business	USA	Germany
widges	25%	30%
whosits	50%	15%

is there a way that I can adjust the data to do this?

[anbu1984]

LOad buiseness,MaxString(If(Location='USA',[Sales Percentage])) As USA,MaxString(If(Location='Germany',[Sales Percentage])) As Germany Group By buiseness;

Load * Inline [

Location,buiseness,Sales Percentage

USA,widgets,25%

USA,whosits,50%

Germany,widgets,30%

Germany,whosits,15% ];

[sujeetsingh]

Use Pivot table

Dimension 1 =Business

Dimension 2= Location

expression as sales percentage

[sujeetsingh]

If you want it to be in the script then follow the below thread

Convert raw to column Generic Load

[alkesh_sharma]

Please find the attached QVW for your reference

[PrashantSangle]

Hi,

Create Straight Table

use Dimension Business,

then 1 : Expression for USA= Sum({<Location={"USA"}>}Sales)

2 : Expression for Germany= Sum({<Location={"Germany"}>}Sales)

Or

Create Pivot Table

use dimesion 1 as Business

dimension 2 as Location

and expression as Sales

Then drag you second dimension to Horizontal from vertical

and go to presentation select always Fully Expanded

Regards