indicators in tables

It would be very useful if we were able to use indicators in tables to compare against other rows. For instance, if I have a column of sales values - I'd like to highlight the cell with the most sales (vs the other cells in that column).


  • 1
    John Wedderburn

    +1 to this!

  • 0
    Ben Rogers

    Is there any solution for this problem?


  • 0
    Josh Cohen-Collier

    Hi guys,

    Absolutely, this can be done!

    The way this would be done is as follows(to highlight the cell in a column with the max value).
    For instance, lets say you have column X, and you want to highlight the max value in column X.

    First, add a hidden data to the table. This can be done via the Properties panel of the table.
    Then, do the following:
          MAX(&Column X),
          COUNTALL(& Column X)

    Note that in the above formula, we are using a results reference to the column X.
    Then, in the Properties panel of the hidden data, set it to be independant.

    In the indicator condition panel for Column X, set the condition up as follows;
    If:  Column X   'is equal to'  Hidden data  then: change background color

    Hope this helps!

    Warm regards,

Please sign in to leave a comment.