How can we help?

New post
5

indicators in tables

Avatar
James Hacker
None
Follow
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).
Date Votes

3 comments

  • 1
    Avatar
    John Wedderburn

    +1 to this!

  • 0
    Avatar
    Ben Rogers

    Is there any solution for this problem?

     

  • 0
    Avatar
    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:
    REPEAT(
          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,
    Joshua

Please sign in to leave a comment.