6 Replies Latest reply: Dec 2, 2012 2:01 PM by whiteline _ RSS

    Struggling with formulas in charts

      Hello,

       

      This is a great community! Thanks everyone.

       

      I have a sales table like this -

       

      ProductQtyRRP (total)Sale Price (total)
      Product A2200160
      Product B15045
      Product C2150120
      Product A110070

      I am trying to create a chart to find the best discount for products.

       

      I think the best way is to show it this way -

       

      x- axis - Discount

      y- axis - products sold at this discount.

       

      I might need to use ranges (0-10%, 10%-20%, etc ) as discounts are usually 5-10-15-20-25. I am not sure at this point how to do it.

       

      Could someone give me an idea what dimensions, expressions I should use for line chart, or if it should be line chart at all? Or maybe there is a better way to use QV to find the best discounts using the data I have?

       

      Thanks.