How to get value of same field from different row in straight table

[manuelrubiano]

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.

Thanks in advance.

[edwin · Accepted solution]

try this expression:  = sum(total <Description> {<Trade={'WM_GT'}>}Price)

[edwin]

will the comparison always be WM_GT?  wouldnt the user want to select it?  if so create a variable that holds the selected trade (assuming user can only choose 1) with expression =only(Trade) 

then in the price expression:  sum({<Trade=>}Price)
and your compare expression: sum(total <Description> {<Trade={'$(YourVariable)'}>}Price)

[manuelrubiano]

It Works. Thank you!

[manuelrubiano]

Yeah. I'll have it in mind. Thanks.