title: Dynamic background color for total cell
body: <p>I'm using Pentaho Report Designer and I would like to change the background of the cell that contains the sum of all the measure values of a column based on the calculated value. For the measure values, this can be easily done defining a formula for the background property like the following one:</p>
  
  <pre><code>=IF([measure] &gt;10; "red"; "green")
  </code></pre>
  
  <p>However, from the cell that shows the total, [measure] is always null. </p>
  
  <p>How can I get the value of the cell (or the result of sum all the measure values)?</p>
  
  <p>Thanks</p>