Forum Discussion
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 below:
the statement above is driven by an excel template. The problem is if I show lines without figures all other unwated lines are displayed so some sort of conditioal display is required
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I think my requirement is not clear. How do you add a blank row in matrix report? for example see below example for the format required after adding the blank rows (in Yellow):
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks It looks like we cannot insert a completly blank column (not showing the index on screen)
