3 Replies Latest reply: Feb 24, 2012 10:02 AM by jagan mohan rao appala RSS

    Sorting only expression

    Paul Damen

      Dear all,

       

      I have a horizontal bar chart, which has only expression (different questions in a questionairre loaded from an excel file). It is counting the number of times a respondend answered that question (1 and 0 in excel). So excel looks like this: 5 colums for every question 1 and then every line is an responded. It says a 1 when the question is answered and  a 0 if not. So far so good.

       

      So the horizontal bar chart counts how many times every question is answered. Now the part that I can't figure out: how to sort the expression, so I only want to see the top 5 of answered question. But since I only got expressions I can't sort it.

       

      I attached the file hope you guys can help!

       

      Regards,

       

      Paul