Forum Discussion

Suryaann111's avatar
Suryaann111
Frequent Visitor
6 years ago

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

2 Replies

  • Mann's avatar
    Mann
    Resolver 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>

    • Suryaann111's avatar
      Suryaann111
      Frequent Visitor
      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