One Measure as pivot data one measure as Unpivot( single) data

[BharathKumarP99]

view: my_view {
measure: revenue {
type: sum
sql: ${TABLE}.revenue ;;
}

dimension: category {
type: string
sql: ${TABLE}.category ;;

}

dimension: month {
type: string
sql: ${TABLE}.month ;;
}

pivot_table: {
column: [month]
row: [category]
value: revenue
}
}

The above syntax is correct to pivot one measure and unpivot one measure, if not any suggestions to solve this in LookML or Table calculations?