I want to show positive and negative values in bar chart.
I have attached sample qvw
here if I select N_Flag=0 it gives me positive values in chart
select N_Flag=1 it gives me negative values in chart
If I do not select N_Flag= it calculates net values(which I do not want)
My requirement is to display positive and negative values in single chart.
Please suggest if there is any solution.
Good Suggestion. But Number of products are not fixed ,they could increase in future. So in such case ,this approach wont work.
For butterfly chart ,need to bring the data in format as given in attached example.
Can consider this option if we can format the data .
Thanks for your Suggestion!!