4 Replies Latest reply: Feb 21, 2012 3:53 AM by DONALD GUNATILLAKE RSS

    Displaying two different results within an expression as different colour bars



      I have a problem which I am sure must be easy to solve, but I'm not entirely sure where to start.


      I have attached a  sample qvw. I have some data showing mileage lost due to a number of reasons, traffic, road closure, staff dispute etc etc. Some of these reasons are chargeable and some are not, I'm trying to work out the easiest way of showing the difference so red bars for chargeable and blue for non-chargeable. I have tried moving category as the main dimension and then type as the second dimension, which provides me with the split but doesn't give me the consistent colour theme.


      Any assistance will be helpful