10 Replies Latest reply on Oct 26, 2017 3:53 AM by daniel.andell

    Color data by column and grand total

    daniel.andell

      I have data that shows account name with sales, percent to PY, Margin, and average sales price. Now I would like to color this dashboard but I would like to use color individually per column.

       

      For example I would like % to PY to show green for + and red for -

      Then I would like Margin to show green if the margin is over grand total and red if it is below

      The same for average sales price, if the customer is above it is green and below it is red.

       

       

      3.jpg

       

      Another question in the same matter is if I could also create a color only for account name column, for example depending on if the customer is private or public

       

      Thanks