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.
Thanks.