Sub query calculation in Products Posted January 13, 2015 I have a table which includes vendors name and their product which they sold to us, how could I generate each product P&L report? For example: Vendor A, Apple, -1Vendor A, Orange, +1Vendor B, Pear, +2Vendor B, Grape, +3
Sub query calculation
in Products
Posted
I have a table which includes vendors name and their product which they sold to us, how could I generate each product P&L report? For example:
Vendor A, Apple, -1
Vendor A, Orange, +1
Vendor B, Pear, +2
Vendor B, Grape, +3