09-19-2022
08:17 PM
- last edited
Wednesday
by
JackLacava
Hi all,
I am trying to apply a conditional formatting to a variances column, if higher than last year then shown up arrow (color red) if lower than last year then down (color green).
Not sure how you can achieve this?
09-20-2022 05:20 AM
Hi KB,
You will find it in the conditional formatting.
Thanks,
09-20-2022 12:59 PM
Hi KB: I don't know of a way to do arrows in a standard cube view. The formatting options that would be most applicable for coloring in a Cube View would likely be:
You would set this in the Cube View > Rows and Columns > (select a report block) > Formatting > Cell Format. Use a condition of If (CellAmount ... ) Then ...
Cheers -DB
09-20-2022 08:27 PM
I have done that with cell format as Wingdings but not sure what I need to include to return a text?
09-21-2022 09:45 AM
1. XFS Cube View Styles in Dashboard -> Parameters -> Conditional_Formatting
2. In Cube Attach this Formatting in the data Section and Make sure you select as Combo Box. so it will return as string.
3. You can use the conditional formation on the Amount Column and that should work.
09-21-2022 12:56 PM
Can you share the content of your Conditional_Formatting parameter. I'm not quite following how this is used.
09-21-2022 01:07 PM
Dashboard Parameters
Cube View
09-21-2022 01:10 PM
My bad, I understood that part.
What is the text/details of the 'Conditional_Formatting' parameter? I assume that is where you have the conditional logic?
09-21-2022 01:16 PM
See below