2 Replies Latest reply: Oct 27, 2015 10:01 AM by liron baram RSS

    Different colors according to value

    Enrique Colomer

      In the example:

      The question to be resolved is pointing different colors (green or red) values in a table as are above or below the total baseline.

      The reference table contains a dimension "Product" and an expression: "% / Total", calculated as

      Sum (Amount) / Sum (TOTAL <Country> Amount)

      If you select a Country in the column Total you have the efect but not in each column in right

      p60.png

      And when you select a country, the efect over total column is ok, but not over the columns

      p61.png

      Tx