sorting order

[upaliwije]

Hi FRiends

I have following pivot table in my QV doc'

I have derived this TOTAL rows with the help of following calculated dimension

=Pick(Dim, BRANCH, 'TOTAL')

I have sorted branch field  with 'Branch No' in descending order since I want to TOTAL row come to the bottom. However due to this my branch order is shown in descending whereas I want it to be shown in Ascending order with Branch1 being shown in 1st row and Total row to remain as the last row . Can you please advise me how to overcome this  issue.

[Kushal_Chawda]

Go to sort tab , for Branch dimension, in Expression (ascending) use below expression

=Pick(Dim, keepchar(BRANCH,'0123456789'), 100)

[jmvilaplanap]

Hi Upali

Maybe you can create a DUAL field with Branch (How to use- Dual()) it will be easy order it later.

Regards

[upaliwije]

Hi Kushal

I have done it but it is not working. Now the TOTAL come in between Branches

[Kushal_Chawda]

make sure you just have expression sort, any other sort like text, numeric, remove that

[upaliwije]

This is how I did it

Still the same result

[Kushal_Chawda]

Remove '=' After branch, due to synatx error it is not showing

=Pick(Dim, keepchar(BRANCH =,'0123456789'), 100)  -> wrong

=Pick(Dim, keepchar(BRANCH,'0123456789'), 100) -> Correct

[upaliwije]

Sorry Kushal

I spotted the error after adding my screen shot and corrected the same , still the report is not sorted the way I want . Now the Total Comes to bottom but other branches not ordered in numerical order.

[Kushal_Chawda]

Would you be able to share the sample?

[upaliwije]

This is my sample Qv doc. pls help