Forum Discussion

samantha75's avatar
samantha75
Frequent Visitor
2 years ago
Solved

Insert Blank lines in Matrix Financial Statement

Hi Everyone Thanks for helping me out with the fin rpeort and I'm very close to the final version. One question I  have is inserting blank lines to separate row sections for example insert a line be...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi samantha75 ，

    If you want to add blank columns to Reporting Heading, you can manually add blank rows to Reporting Heading in the dataset.

    And then add an index column, sort it, and return to desktop to generate blank rows.

     

    Hope it helps!

    Best regards,
    Community Support Team_ Tom Shen

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi samantha75 ,

You can see that you have correctly added blank rows to your matrix, but you want to hide extraneous columns and don't want the extra blank columns to appear.

You can create a new table to hide other columns from you.

Table2= SELECTCOLUMNS('Table',"ReportHeading",[ReportHeading],"Operator",[Operator])

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.