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...