Insert Text row in crosstable

In a crosstab, you can insert text rows to create a better overview of your data.

This crosstab shows a number of accounts:

- now we want to add some headers for different groups of accounts.

We right click on the first account dimension value and choose add text row:

This gives us some controls on the panel placed left hand side:

You can add dynamic content and choose to align data - or just add your own header.
In the Comment Text box we remove (cellvalue) add a linebreak type Sales and add another linebreak - now the table look like this:

If we right click the newly added textrow and choose format this member - we can change font, size and formating of the text Sales:

Repeating the proces a few times, your table might end up looking like this:

Note: When you insert a text row, the text row is inserted relatively to one of the existing rows. E.g., from the above example, the "Tax and Interest" text row is inserted relatively to (above) the "645100 INSURANCE" row. If the "645100 INSURANCE" row is moved, the text row will move accordingly. Furthermore, as a consequence, if the "645100 INSURANCE" row is missing (e.g., if a filter does not include this row), then the text row will be moved to the bottom of the crosstab.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.