Box borders for select rows
Hi team
How do I create a border across rows and columns, essentially creating a box around them? The use case is for showing the detailed amounts for a subtotal in the AFS, contained within the bo...
Forum Discussion
I tried this, as well as variations of this condition, but it won't work because of the way I've set up the rows and columns. Thank you though! It'll definitely come in handy with other reports.
Reasons it won't work:
- .Base is being used for dimension members on the columns.
- This results in the borders being applied to the left/right of each column, instead of only on the most left/most right column.
Where there's a will, there's a way!
A few things that you could try:
1) If you know the member name of the first and last members you could change the if statement to look at the member name instead of the column name "If (ColE1MemberName Contains..."
The same could apply to rows using RowE1MemberName
2) You could add a 'blank' column as the first and last columns use additional settings to change the columns widths, font colour, etc of these columns.
Mark