PowerPivot - How to preserve the sorting order in Text fields?

[paulkltam]

For PowerPivot, can anyone tell me how to preserve the text fields sorting order, neither ascending nor ascending order, after refreshed? For instance, "John, David, Peter, Ann", and my prefered sorting order is "John, Peter, Ann, David".

 

[Useful]

Hello,
it is possible to sort it as you desire. First create your "sort order table" in excel which consiste two columns (names and numbers). Copy and paste it from power pivot window (after this you'll not need to keep the copied excel table anymore so you may delete it). Ok now use =LOOKUPVALUE() function to get index numbers of the names and sort the index columns then your result will be ready.