sorting problem

[#1]

Hi All,

Could any body tell me why my sorting is not good?

if you look at the 5th rows of the cross tab you'll see that is not sorted in total.

Thanks

[giakoum]

really amazing...

[#3]

I know why but I don't know how to fix it.

We have Vendors name which belong to different Expense type.

so it crashes the sorting but I don't know what to do

Any idea is appreciated.

if you select the not sorted one you will see it !!!!

[CELAMBARASAN]

Hi,

Use sort by expression as

= Sum(Total<EXPENSE_TYPE,VENDOR_NAME> {$<VENDOR_NAME=>}  AP_TRAN_TOTAL_CURRENCY)

[#5]

Thanks for replying but it does not work this way too.