Table header format

[Suryaann111]

Hi All

One help needed.
I have two columns in the source
Sales_bp. Sales_dp
23. 30
12. 34
I want to show this column in a table visual as


Sales
Sales_bp. Sales_dp
23. 30
12. 34
Need an additional header column sales under that salesbp n salesdp column headers.
Kindly help

[Mann]

Hi @Suryaann111 

You can use Matrix visual for this.

Also I believe you want to show these values against some dimension. I have taken "ID" as dimension here and the source table schema is:

Create a Calculated Column for your main header i.e. [Sales]="Sales"

Then use Matrix as shown below:

Note: Instead of ID you can use the dimension/attributes you have in your table for which you want o show this data.

Mann
<If this post helps, then please consider Accept it as the solution to help the other members find it more quickly>

[Suryaann111]

Thanks for the solution.
What if I have to show a different header on top of ID column instead of sales.
Project sales
Id. Sales dp. Sales bp
1. 12. 23