Custom Cross-Tab Data Table - Need help changing the way data is formatted in the table

[Anonymous]

Below is an example of a report I created. In the settings of the cross tab, I selected "Format > Values > Show on Rows" to show this view.

However, my manager wants me to be able to show the data in this format where the Act, Bud and Var are on the same line for each metric but under the specialty.

This is how my data is structured in the data table. 

Can anyone help me figure out how to display the data in the desired format?

[amitchandak · Accepted solution]

You have to create a table and display that like one given below

new table =
union(
summarize(table,table[speciality],"name","Comp-phy-comp","Act",[Comp-phy-comp act],"Bud",[Comp-phy-comp bud],"Var",[Comp-phy-comp var]),
summarize(table,table[speciality],"name","Comp-app-comp","Act",[Comp-app-comp act],"Bud",[Comp-app-comp bud],"Var",[Comp-app-comp var])
)

[Anonymous]

THANK YOU @amitchandak !!! That works. I have not used the new table feature before so I didn't know that existed. I really appreciate your help.