Forum Discussion

Rosina's avatar
Rosina
Regular Visitor
7 years ago

sub heading with calulated columns

Hi All,

 

I am currently building a report, the user wants it to look like her excel report that has headings and sub headings

 

 

I have managed to duplicate the rows using calculated formulars but I have no idea how to add the "planned" "gained" headers

 

I can't just add a text box on top as the table has manay columns so can scroll left or right

 

Thanks

 

Need Help

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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.

    • Rosina's avatar
      Rosina
      Regular Visitor
      7 years ago

      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

       

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        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.