2 Replies Latest reply: Feb 20, 2013 7:29 AM by Bhaskar Sharma RSS

    What if Analysis

    Bhaskar Sharma

      Hi,

       

      I want to do a What-If Analysis. I have a Bar chart that shows the Sold Volume. Along with the Bar, I want to put another Bar that will be Sum of Sold Volume + Pipeline deals volume.

       

       

      In the attached file, you will see a listbox that gives my Top 5 deals in pipeline. Below the listbox there's a chart with 2 Bars. The first Bar is my Sold Volume. The Second Bar is a what-if Sold Volume, which is the sum of Current Sold Volume and whatever pipeline deal I select from the Listbox above.

       

      I want to see what will my Sold Volume look if any of the selected deals could be sold.

       

      Please let me know if you need more information. Any help will be greately appreciated.