1 Reply Latest reply: Aug 26, 2015 5:33 AM by Tresesco B RSS

    Hide irrelevant secondary dimension values in bar chart

    Stevan van der Werf

      Hi Everyone,

       

      I want to create a bar chart which has two dimensions. The dimension value of the second dimension should be grouped within the corresponding first dimension value. I succeeded in creating a chart which does that:

      2015-08-26_105656.png

      As you can see, I have different kinds of fruit, grouped by color.

       

      How can I hide the irrelevant values of the second dimension. I want to show the group 'Blue' which only contains the number of 'Grapes', the group 'Red', which contains the number of Cherries and Tomatoes, and finally the group yellow which only contains the number of Apples and Bananas (so no cherries, grapes or tomatoes here).

       

      Is this possible?

       

      My .qvw is attached.

       

      Thanks!