How do you handle conditional formatting based on the value of other rows and columns?

Answer

• This has been requested numerous times via Tickets & Enhancement requests and is currently in process by our Development Team
• Only known workaround:
  
  • Call an XFBR string rule in a cube view row to dynamically format a column
  • For each row you want to apply this logic for, you would need to pass in the exact intersection to check the “SourceColumn” for into the rule to retrieve the row’s “SourceColumn” value and determine how to dynamically format the column for the given row
  • This workaround would not be dynamic.

 

Source: Office Hours 2020-11-05 Partner Enablement