2 Replies Latest reply: Aug 15, 2017 12:00 PM by Vishwarath Nagaraju RSS

    Question

    D.R.NEVILLE DHAMSIRI DHAMSIRI

      HI!

       

      My question is as to how I could exclude records from my pivot table which are in order.Only the records which are not in order to be displayed. Data presentation is as follows:

      Ref_Number               Paid commissions          Allowed commissions     Excess(If Any)

      RA00D125                    500                              500                              -

      RA00D126                    1000                              750                              -250

      RA00D131                    750                              500                                -250

       

      I need only negative excess to be shown in the data presentation.

       

      Neville