0 Replies Latest reply: Jan 28, 2010 5:49 PM by sch RSS

    Setting Goals


      I'd like to set a goal on a chart based on a few pieces of information. How do I create a reference line on a chart to express a goal in dollars where:

      1. A ship date is not null

      2. and the product is of a particular type

      2. then multiply the total units shipped by a given dollar value per unit .

      If ShipDate Not Null and ProductType=Bike, then multiply the total Bikes by $100.