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.
