I have a simple table, with "product name", "value" and " date of entry"
each product has several "dates of entry," where each "date of entry" it has a different value, for example:
A___01/01/08___200
A___02/02/08___50
A___03/03/08___140
B___10/01/08___88
B___20/02/09___100
B___30/03/10___360
but I don't want repeat the products (name), I want to show only the most recent. For that, I'm using "maxtring" in my "date of entry"(expression), so that it appears only the most recent date, but he brings no value... example:
A___03/03/08___ -
B___30/03/10___ -
- = (null)
*in the "value", I am not making any kind of calculation, I'm just bringing the "value" field
I think this happens because there is no relationship between the "date of entry" and "value", so it brings the most recent date, because I used a formula, but do it not know what value should bring ...
Anybody knows an expression I can put in "value" for it brings the value corresponding to the date?
can someone help me?
