How to get value of same field from different row in straight table
Hi everybody. I would appreciate some help with this:
I'm trying to get the value of field price in everyrow but from a specific value of field Trade. For example what i'm expecting is column compareprice of the next table. Where compareprice is the value of price where Trade = 'WM_GT'
The next step is i can choose dynamically the Trade i want compare to every row for anyone combination of Country, Family, description and seller.