8 Replies Latest reply: Sep 4, 2012 11:13 AM by m w RSS

    Creating chart with Sum expression and multiple condition

      I am trying to develop a bar chart.


      In the expression tab i have two expressions.

      One of them shows me the selection value, while other gives me a benchmark value.


      Now for creating the benchmark bar i have to apply the following crtieria :

      1. It follows a particular business line only.
      2. It should not be affected by the salesman selection.


      So i wrote the expression as

      sum ( {<businessline={'RT'}>}  {<salesman_name=>} ear_prem_usd)


      Now, because i have two conditions in the sume expressions, the second condition is overriding the first condition.


      Please help....

      Its really important and urgent...