How to give serial no to any dimension from shot tab

[#1]

Dear All,

I have a table :

A      B

AA    10

ZZ     20

OO    30

MM    40

I want in pivot table that Column a will give this sequence :

A      B

ZZ     20

AA    10

MM    40

OO    30

Please tell me want expression i have to write in SORT TAB of pivot properties to view this type of sequence.

Regards,

Rahul

[christian77]

Hi.

I don't know your model but I can tell there is not order in your dimension aparently so you need to create the order in an inline table with 2 fields:Field1, OrderField1. Fill up the inline table and then in your sort tab use expession max({1} OrderField1)   ---> Ascending.

The max({1}) ensures there is not other sorting due to filtering.

[bbi_mba_76]

Sorry, I don't understand the criteria to sort. I think you could load the A field with the correct order in the script, so you could use the load order option, otherwise you should add a load inline adding the A sorting and use the Asort field

LOAD * INLINE [

    A, Asort

    ZZ, 1

    AA, 2

    MM, 3

    OO, 4

];