Forum Discussion
sub heading with calulated columns
Rosina ,
You can simply create a matrix visual and drag [Headers] column and [Subheaders] columns to the column field. If values "Planned", "Gained", "Lost" and "Delayed" are columns' names in your original table, you can click query editor-> Transform, then click unpivot to transform them to column values.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuta-msft thanks for the reply, it is a matrix visual at the moment. I am finding it had because the columns ae calulated from different tables and columns. I have sub headings on another table but that is because I group the columns, not sure how to do this when multiple columns are involved.
Also Planned, Gained ect are not columns in my actual data
Rosina ,
Does this tables have relashonship with each other? Could you share some screeshots of table structure and relashonship? Please mask the sensitive data in snapshot.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.