6 Replies Latest reply: Aug 20, 2014 4:45 PM by Saradhi Balla RSS

    Help with expression in chart, and suppressed values

    Nemanja Momic

      Hello all,


      As you have read, I have a small problem that I cannot solve on my own.


      I need to sum all red values, so that I can get the percentage marked in green.

      The blue values should be suppressed, and the final chart should look like picture 2.

      I have tried with Len(trim(Location)>0, Location) as a calculated dimension, as well as adding same conditional to the expression.


      Also I have attached the sample qvw with scrambled data, which is the application that I'm having trouble with.


      Thanks in advance