Forum Discussion
Customized header grouped on 2 lines
Hi guys, I want to reproduce something like that in a matrix: Buet my yitles are made by hand in Excel but I want to avoir any manipulation in Excel, any solution ? Thanks !
This You can achieve with the help of data modeling and custom table
To achieve this Your data should look like as below. Then with the help of swith dax measure you can pass your result.
My data look more like this :
| CODE_RSS | Établissement | DOMICILE | CH | Ri-RTF | AUTRES | CHSLD |
| Total | 640 | 633 | 182 | 116 | 246 | |
| a | abc | 239 | 173 | 68 | 44 | 26 |
| b | def | 168 | 271 | 62 | 10 | 67 |
| c | ghi | 138 | 176 | 20 | 14 | 36 |
| d | jkl | 77 | 60 | 14 | 18 | 50 |
| e | mno | 55 | 71 | 9 | 4 | 5 |
| f | pqr | 54 | 16 | 12 | 7 | 64 |
| g | stu | 46 | 54 | 14 | 4 | 36 |