Sorting Issue

[upaliwije]

Hi Friends

I have folowing pivot Table in my QV doc.

My current output is shown in first statment and required report is shown below. In fact I want to sort my report (branch Column)as per ratio colum under Non_payment catagory. I have tried with follwing expresion in sort tab. But it does not work. Pls help me.

[Anonymous]

does the Pivot table show "NON_PAYMET" instead of "NON_PAYMENT" in MAIN_CATEGORY?

[upaliwije]

Yes Rudolf,

I have made a mistake there. I  have corrected it still the report is not what I want .. Pls help

[Anonymous]

can you post qvw?

how Comes that branch A now has total of NOS=49 and Refund2016 = 1666665

in required ouptput branch a has total of NOS=31 and refund2016 = 626387?

no branch Shows the same figures like in your first post

[upaliwije]

Yes What you say is correct. I am not in a position to share the Qv file. If you go by my last report forgetting the earlier one it is sorted on Value Column and  not % column. Can you suggest me a way to sort it according to Ratio. Pls help.

[prieper]

Hi,

you only need to repeat (copy & paste) exactly the expression used for the Ratio within the sorting option for BRANCH.

Peter

[Anonymous · Accepted solution]

I made a short sample

I defined the sort for Dimension branch to "=sum({<Main_Cat={'Non-Payment'}>}Refund)/sum (total BRANCH> Refund)

it's sorted by Ratio of non-payment