I have some calculated columns and need double headings as below. All the columnsI just want to group the column headings and they are not linked to the data. Please can someone help on how to achieve this.
Go to Solution.
@bml123 yes it is possible to achieve this result. first you organize your data in below order. Then using matrix visual, you can create output table as per your need.
View solution in original post
Hi @bml123 ,
Create 3 text boxes for the following:
Place these text boxes just above the headers of the matrix that you want to be included under these headings.
Proud to be a Super User!
@bml123 , refer if this can help
The easier way is to have text boxes on top of the matrix columns.
I don't want to use text box as the width of the columns are not fixed.
@bml123 , check 2-3 links I shared
Thank you. How do I arrange the data in that order? Do I need to do unpivot?
@bml123 You would need alleast 3 columns (1. for Calculation type 2. Target 3. Actuals) I suggest you to share your data, I will then assist you accodingly.
Thank you. I could organise the data as you mentioned. I followed the link below for any one needing help like me.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021