Hi Pawel, thanks for replying.
I see what you mean now - and agree that this is a function that should be available, but I can't see this function at the moment.
However a consolatory fix could be this:
Create the following calculation
CASE WHEN Task Category= 'Standby' THEN 1 ELSE (CASE WHEN Task Category= 'Urgent' THEN 2 ELSE 3 END) END
or if there are more than 3 Task Categories
CASE WHEN Task Category= 'Standby' THEN 1 ELSE (CASE WHEN Task Category= 'Urgent' THEN 2 ELSE (CASE WHEN Task Category= 'Overtime' THEN 3 ELSE NULL END) END) END
Adding this new calculation as a column, and then sorting by this calculation A-Z.
I know this isn't *exactly* how you would have wanted to go about this, but it is a way that would work!
When You mean to add it as a new column You mean during the Data Flow process right?
Agreed, definitely not a final solution but I'll test it. Thanks.
Great, let me know how it goes! I think it should work, but if not please let me know and i'll try to think of something else!
Nice Solution LSharm, but in this case, do we have to pull the second calculated column as well in the view?
What I meant is can we hide this calculated column or something? I do not want to pull this in my report or graph.