How to Split cells in matrix table

[Ganesh08]

Hello Guys, I want to make a matrix table on Dashboard, like the one below. Problem is there are constants that i have to insert manually and does not exist in the data base, same for Area and Activity. I have the measures from the data. I dont know how to split cells in matrix table and add constants with conditions. Can you please help me

[amitchandak · Accepted solution]

@Ganesh08 , check if the calculation group can help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0