Calculating total amount in pipeline deals


#1
  measure: total_pipeline_amount {
    type: sum

    filters: {
      field: is_pipeline
      value: "yes"
    }

    sql: ${loan_amount} ;;
  }