Hi All,
I have three table in my database
1) products with two columns - product, price
2) region with two columns - SalesPerson, Region
3) transactions with five columns - date, SalesPerson, Product, Discount, Units
I want region wise net revenue. Calculation for revenue is ...