I want a stacked bar graph so that both the measures would add upto total. How to do that?
Lets say I have sum(male)=100 and sum(female)=90 measure. Now when I put it in dual axis, it shows female in one colour at 90 and the rest 10 of male as another colour. What I want is 90 female and on top of that 100 male so the total value comes upto 190 on the scale. Is this possible?