Please help me get the desired formatting in matrix view

[Captankit]

Current view in matrix:

Desired view

[Captankit]

https://docs.google.com/spreadsheets/d/1IhnDV7nyywLlxUhcuomit9bgsGfmhWp9/edit?usp=drive_link&ouid=11... 

[lbendlin]

Like this?

[Captankit]

Nope, This I have acheived that by providing conditional formatting. I want colour in the rows totals of only bedroom view. 

[lbendlin]

like this?

[Captankit]

This also has been acheived, I have provided the required formatting of totals where I need to concetenate all the tab into single line for the row headers and then colour the row totals only including the coloum totals but only for row headers, not all

[lbendlin]

link asks for access

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[Captankit]

https://docs.google.com/spreadsheets/d/1lNaClqY8UtuFdGIvAF5Ei_DPGcpUCCX-/edit?usp=drive_link&ouid=10... 

Please see attached excel sheet with master data and required format