Forum Discussion
Suryaann111
6 years agoFrequent Visitor
Table header format
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
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
2 Replies
- MannResolver III
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>- Suryaann111Frequent VisitorThanks 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