3 Replies Latest reply: Jan 24, 2014 8:26 AM by Carlos Reyes RSS

    Scatterchart with conditional values. How to?

      I’m struggling with development of a scatterchart that will show two dimensions:

      X axis – store sales

      Y axis - %  share of Product category Z in total store sales

      I want the chart to include groups (store / chain) so that I can switch between store and chain and of course I want to be able to switch between time periods (days, weeks, months)

      My main problem is what formula I should use to calculate % share?

      Thank you very much for your answer

       

      regards.

       

      Thomas