2 Replies Latest reply: Sep 12, 2012 4:00 PM by whiteline _ RSS

    Filtering Help Needed

      Here is what I am trying to do....I have two dimension columns one with unique order numbers another with the payment amount.

       

      If you look at the example below orders 001 and 004 have two entries as Payments were made then refunded.

       

      Basically I want the orders  not be shown whereby the total in the payment column equals $0

       

      So in the below example only order 002 and 003 should be shown in the report.

       

      Any help would be great!

       

       

       

       

       

       

      Order NumberPayment
      001$100
      001($100)
      002$345
      003$490
      004$250
      004($250)