OLAP Table Conditional Formatting based on value of an in-row KPI

This is in a view.

Hi @trevor.nixon,

You were in the good direction with creating a Custom Object. You need to create one that looks something like this:

  - id: CO_DISPLAYRULE_10_flag

    displayName: Display Rule for 1 or 0 flag

    customAttributes:

      - comparator: EQUAL

        value: 1

        style:

          backgroundColor: "#00b612"

          fontWeight: bold

      - comparator: EQUAL

        value: 0

        style:

          backgroundColor: "#ff6242"

          fontWeight: bold

Note that you do not have to specify any KPI here, it just looks to the value.

Next step is to apply this in you OLAP table field:

Your result will look like this:

I hope this helps!

Is there a way I can apply this to other cells in the row?

You sure can! Since the Custom Object is not applied on a KPI/column but just to the values 1 and 0, you can add it to every column with these values. Just follow the step in the screenshot of my previous answer.

If this answer helped you, please accept it to help fellows with the same question.

I don't think I phrased my question very well-

in an OLAP table, is it possible to alter one column based on the contents of another?

OK - thank you for your answer.