Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a DB table with user / phone call and cost and I'd like to show it in a pivot table sorted by user/cost.
It is possibile to set the Y-order only in the first colums, so the phone cost are sorted correctly, but I lost the user order.
Viceversa, if I set the sort using a formula on the right colums, the user sort is correct, but the cost one is wrong.
In the attached print screen you can see what I mean.
Could anyone help me, pls?
Thanks.
N.
Perhaps sorting by this expression works: (Max(total Utente) - Utente) * 1000000000 + sum(Costo Traffico)
Thank you for you prompt replay, Gysbert.
To tell u the truth the User field is a string ("1 - Mario Rossi"); I hid the name for privacy reason. I'm sorry if it has driven u on the wrong way.
I can't understand why the solution with the expression Sum(Costo) in the called number column doesn't work correctly: it seems the most logical...
Thanks.
N.