Hi All 

I have a power pivot table that is keeping track of voucher unredeemed balances. The way I have achieved this is from 3 tables ie:

table 1 = original voucher value

table 2 = redeemed value

table 3 = cancelled value

The above tables all have a barcode field that is unique in table 1 but can appear multiple times in the remaining tables. I have created a measure in each table for the total value columns in each table. I have then created another measure that gets the remaining vchr balance liability from table 1 vchr value less table 2 redeemed value/s and then less table 3 cancelled value/s. This remaining balance column in the pivot table naturally has many nil balance vouchers once they have been fully redeemed and/or cancelled. I would like to then sort the row that shows the voucher number by the remaining balance column for all vouchers valued above zero. I know how to sort using another column's criteria but I can't figure out if it's possible to filter out the nil value entries?

I hope I have explained this clearly enough for someone to be able to help me?

Thanks everyone