title: Cognos Report Studio 10.2.1: how to split query calculation formula and display as stacked bar chart
body: <p>I am creating a sales incentive model report. I am having base salary and commission rate as a parameter . I need to display base salary and commission as a stacked bar chart which is nothing but compensation(sales*commission rate/100+base salary).The graph has to change based on the above two parameters. I am getting compensation as a single graph but I want to achieve like below link base salary mirrored with commission.</p>
  
  <p>For the reference please check the below link.In the link please scroll down and go to "what if" analysis" tab.Check the second graph as I exactly want to achieve.</p>
  
  <p><a href="http://www.tableau.com/solutions/sales-reporting-and-analytics#" rel="nofollow">http://www.tableau.com/solutions/sales-reporting-and-analytics#</a></p>
  
  <p>Kindly help me in creating this report</p>
  
  <p>Thank You</p>