Conditional formatting in cube views

[STDN1610]

Hi Team,

I  am building a cube view  with 8 columns and need to set up the color formatting to it which is yellow color for total values in first 4 rows/columns and red for negative numbers , green for positive numbers in the next 4 rows/columns , can anyone suggest.

Thanks in advance.

[IftaqarAhmed]

It depends on your approach. You can apply conditional formatting to either the rows or columns, but be sure to follow the cube view processing order of operations (such as Number Format from app properties, CV default, Column Formatting, Row Formatting, etc.). Since you’re focused on Cell Formatting, I’d recommend using the Cell Format Dialog box for this purpose (refer to the screenshot below for details). Additionally, I suggest creating literal value parameters to centrally manage instead of hardcoding in each cube view you build. You can also use CV extender business rules to manage this.

The Design & Reference guide has some excellent examples, so be sure to check it out.

If this solution meets your expectations, please mark it as accepted.

I hope this helps!

Thanks,

Iftaqar