How to get required order in pivot table

[#1]

Hi,

I have one pivot table with column as manager.

I need to get the manager order as

Carl

Adam

Caty

Ciasel

Rosy

Revanth

Dolly

Damein

Daniel

Seara

David

Christ

Amal

Durga

Candsy

Cattie

could anyone let me know how to get this order in the pivot table when I make any selections. Now I have this in ascending order. But I would need the order which I shown above.

Please could anyont help me.

Thanks.

[Clever_Anjos]

Create another table:

LOAD F1 as Manager,RowNo() as RequiredOrder INLINE [

    F1

    Carl

    Adam

    Caty

    Ciasel

    Rosy

    Revanth

    Dolly

    Damein

    Daniel

    Seara

    David

    Christ

    Amal

    Durga

    Candsy

    Cattie

];

And use "RequiredOrder" as an expression into Sort Tab of your table

[#3]

Hi,

Thanks for your answer. I am getting duplicates when I used column manager in pivot table and in list box.

Could you help me why it is getting duplicates

[v_iyyappan]

Hi,

Try like this,

Test:

LOAD

    Recno() AS ID,

    Dual(ManagerName, Recno()) as RequiredOrder;

LOAD * INLINE

[ManagerName

Carl

Adam

Caty

Ciasel

Rosy

Revanth

Dolly

Damein

Daniel

Seara

David

Christ

Amal

Durga

Candsy

Cattie];

Regards,