Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a costprice table wit 3 FIELDS
ITEMID | COSTPRICE | MODIFIEDDATE
i need anytime the last costprice per ITEMID
can u explain me how i can get these values in an expression?
Create a Straight Table
Dimension
ITEMID
Expression
FirstSortedValue(COSTPRICE,-MODIFIEDDATE)
Create a Straight Table
Dimension
ITEMID
Expression
FirstSortedValue(COSTPRICE,-MODIFIEDDATE)