• Use UNPIVOT to turn each PAYMENT_TYPE into its own column. See the following link.

    Then your calculation should be easy 🙂