Matrix visualization_ need help

[Avry_th]

Hello all,

would really appreciate if any could help me with the matrix table look a like as below: 

i did have my product list as the row ( FTTH, ADSL,DPLC ect..) 

i have Gross Revenue Net Revenue. 

but i really have no idea how to have my matrix table look exactly the same to template above.

Thanks in advance for your help.

[lukiz84]

Please see Calculation Groups - SQLBI

If you have specific questions after reading and understanding this article, please feel free to ask 🙂

[Avry_th]

hello Lukiz, 

thanks for sharing the article. i have learnt sth new. 

however, i guess that was not what i am looking for. maybe my sample table was not make enough sense. 

my problems is: i was trying to have my matrix table look the same to the sample.

-  i have my Gross Revenue Measurement, Net Revenue mearsurement and % to be shared column as the values. so it not allow me to add it to column section. 

- the Rev.type1 and Rev.type 2 are the catergories column.

so i have tried around and i only get the below: