2 Replies Latest reply: Oct 14, 2013 4:54 AM by ALEXIS TAN RSS

    Doing a Count of Dimension

    Nayan Lalla

      Hi

       

      Below i have a a sample of my data.

       

       

      Voucher_NumberDecoder_CodeClaim_DateClaim_Status
      SD8 316785V10139142428/08/2013Rejected
      SD8 316785V10139142410/09/2013Rejected
      SD8 316785V10139142425/09/2013Accepted
      SD8 316785V10139142427/09/2013Rejected

       

      I want to create a straight table chart showing the count of claim status.

      •      One column for Count of Rejection and Once column for Count of Accepted with only one dimension which should be the Voucher_Number.

       

      The result im looking for should be as follows.

       

      Voucher_NumberRejectedAccepted
      SD8 31678531