Forum Discussion

AllisonM's avatar
AllisonM
New Contributor II
2 years ago

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...
Cube View
AllisonM's avatar
AllisonM
New Contributor II
2 years ago

MarkBird's avatar
MarkBird
Contributor III
2 years ago

Hi AllisonM 

Where are you looking to apply this?

I'm don't believe it is possible in cube views, but I'm sure it can be done in Excel or PDF reports using conditional formatting. The logic would depend on how you have configured your cube view, so we'd need a bit more information on how you are building the report to give advice.

Mark

  • AllisonM's avatar
    AllisonM
    New Contributor II
    2 years ago

    Hi MarkBird 

    Thank you for your reply! Yes, it would be for Excel and PDF reports. The cube view is setup as follows:

    • The flows required to be contained in the box are indicated in red in the screenshot attached.
    • The subtotal for this flow will be included in the row above.

    Allison

    • MarkBird's avatar
      MarkBird
      Contributor III
      2 years ago

      A starter for 10 (note, it only applies the excel formatting for now):

      You could try adding something like this to the default cell format of the cube view:

      If (ColName Contains 'LEFT') Then
	ExcelLeftBorderColor = Black, 
	ExcelLeftBorderLineStyle = Thin, 
Else If (ColName Contains 'RIGHT') Then
	ExcelRightBorderColor = Black, 
	ExcelRightBorderLineStyle = Thin, 
End If

If (RowName Contains 'TOP') Then
	ExcelTopBorderColor = Black, 
	ExcelTopBorderLineStyle = Thin,
	ExcelLeftBorderLineStyle = None, 
	ExcelRightBorderLineStyle = None, 
End If

If (RowName Contains 'BOTTOM') Then
	ExcelBottomBorderColor = Black,
	ExcelBottomBorderLineStyle = Thin, 
	ExcelLeftBorderLineStyle = None, 
	ExcelRightBorderLineStyle = None, 
End If

       

      It would require that you add 'LEFT' / 'TOP' etc to the relevant rows and columns, e.g. :

      AssetArise > 'Asset Arise LEFT'

      ContrRec > 'ContrRec RIGHT'

      • AllisonM's avatar
        AllisonM
        New Contributor II
        2 years ago

        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.