sorting issue

[amien]

What i want is that all Teams are grouped first (Based on the first 3 letters) .. and then ordered by Progress. See attachment.

See BBB Team should look like this:

BBB.005 , Text, 60
BBB.012 , Text, 40
BBB.022 , Text, 30
BBB.002 , Text, 15
BBB.003 , Text, 10
BBB.004 , Text, 10

LOAD * INLINE [
Team, Description, Progress

AAA.002 , Text, 5
BBB.002 , Text, 15
BBB.003 , Text, 10
BBB.004 , Text, 10
BBB.005 , Text, 60
BBB.012 , Text, 40
BBB.022 , Text, 30
CCC.027 , Text, 5
CCC.028 , Text, 65
CCC.032 , Text, 55
CCC.033 , Text, 30
CCC.039 , Text, 15
];

[oxiofrt]

Hope this will help.
If first 3 caracters are the team (and probably last 3 are the members of the team), you should probably create the team dimension in the script.

[amien]

hi

the output is ok .. only think is that i dont want to see AAA dimension .. when i remove that one .. it is just sorted on progress and not on team anymore

[oxiofrt · Accepted solution]

Infact the matter is that you would like to sort the same column (Team) by 2 sorts : left(team,3) first and then progress.

In straight table, you can hide columns (you can't with pivot table). But you will not have subtotals... (see attachment)

[amien]

Thanks