3 Replies Latest reply: Jun 5, 2014 5:07 AM by Michele Barini RSS

    CASE ISSUE

      Hi All,

       

      I have a data as shown below

       

      PRODUCTPAYMENT_TYPESTATUSVALUES
      TTCCCTIER165
      ASDCASHTIER234
      DFDCCTIER154
      VGFDCTIER332
      BGHCASHTIER534
      NGTONLINETIER656
      ERTCCTIER745
      FDVCCTIER456
      FDEDCna67
      JKLCASHna45
      OPIONLINETIER245

       

      1) I have created a pivote table expression (=SUM(VALUES)

      2) I have all the above information in the pivote table.

       

       

      Issue: For few products (ASD & DFD I want the "STATUS" as null and for rest products it shold reflect from the data

       

      Thanks in advance...

       

       

      Regards,

      KK