Putting 2 or more dimensions below each other in a straight table

[#1]

Hi

I am needing to put more than one dimension in a table so that they are below each other instead of next to each other like it normally does so it would look something like this:

Dimensions	Data
Store 1	100 000
Store 2	150 000
Store 3	75 000
Store 4	50 000
	375 000
Product 1	25 000
Product 2	125 000
Product 3	150 000
Product 4	75 000
	375 000
Region 1	225 000
Region 2	150 000
	375 000

Does anyone have any suggestions of how to achieve this? Using cyclical dimensions and things like that are not going to work as they need the report in this format for a specific reason.

Thanks

Colleen

[its_anandrjs]

use same field name for this in your script load.

[its_anandrjs]

You have to load a table like this

Store:

LOAD * INLINE [

    Store, StoreAmt

    Store 1, 100 000

    Store 2, 150 000

    Store 3, 75 000

    Store 4, 50 000

];

Product:

load * Inline

[

  Product , ProdAmt

    Product 1, 25 000

    Product 2, 125 000

    Product 3, 150 000

    Product 4, 75 000

];

Region:

LOAD * Inline

[

  Region,RegionAmt

    Region 1, 225 000

    Region 2, 150 000

];

Final:

LOAD

    Store as Dimensions,

    StoreAmt as Data

Resident Store;

Concatenate

LOAD

  Product as Dimensions,

  ProdAmt as Data

Resident Product;

Concatenate

LOAD

Region as Dimensions,

RegionAmt as Data

Resident Region;