Field Issue

[vanderson009]

Hi Guys,

I have below data in my table,

Region	Type	Sales
North	Actual	456
East	Actual	348
South	Actual	123
West	Actual	487

I want to display it in pivot table as

But my problem is, I have not Target Type in my Type column, I have only Actual Type, Can you please help me how can i achieve this scenario. 

Thanks and Regards,

Villyee.

[swuehl]

As an alterantive, create the Target type in the script:

Fact:

LOAD Region, Type, Sales

FROM YourTable;

Concatenate (Fact)

LOAD *, 'Target' as Type INLINE [

Region, Sales

North, 4000

East, 4000

South, 3000

West, 3500

];