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