Custom dimension with dollar sign and preservation of commas.

[DougVanHorn]

I have been trying to accomplish the following through many iterations over the past couple of days with no success.

I would like to create a Look that resembles the following:

I have managed to get to the following with various forms of LookML and a custom dimension from the Looker UI.

I am doing all kinds of hiding columns from the visualization to come close to the report that our internal stakeholders are looking to have provided.   In the Look, I created the “Current Year Budget” as a custom dimension to move it out of the pivot table, which worked.   However, I lose the formatting ($#,###0.00) which is important to the internal stakeholders.   NOTE: The current balance and current year budget have the following LookML:

  measure: adjstd_current_balance {

    type: sum

    sql: case

    when ${account_type} = 'L' then -1 * ${current_balance}

    else ${current_balance}

    end

    ;;

    label: "Current Balance"

    value_format: "$#,##0.00"

  }

  measure: current_year_budget {

    type: sum

    sql: ${budget12_current}

          ;;

    label: "Current Year Budget"

    value_format: "$#,##0.00"

  }

The custom dimension uses the current_year_balance.

I tried to concatenate a dollar sign to the custom dimension but lost the commas.

Any guidance/assistance would be greatly appreciated.