Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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,