If you have single records per RepName and UpdatedDateTime, you don't need the aggregation:
First Expression: =FirstSortedValue(ForecastValue, -UpdatedDateTime)
Assuming your UpdatedDateTime is a QV timestamp with a numeric representation (dual value). If not, use a timestamp interpretation function like timestamp#() in your load script.
I used your first expression and I get the following:
What need to see it only the most recent record and it should be the top one?
What should I be doing with the second expression?
The ForecastUpdated field is derived in the load script as follows:
Date(Date(YN_ADD_DATE,'YYYY/MM/DD') + Time(Time#(YN_ADD_TIME, 'hhmmss'),'hh:mm'),'DD/MM/YYYY HH:MM') as ForecastUpdated,
image003.png 11.3 K
As swuehl suggested You should use
RepName (Dimension) = RepName
BudgetValue (Expression) = Your Expression
ForecastValue (Expression) = FirstSortedValue(ForecastValue, -UpdatedDateTime)
UpdatedDateTime (Expression) = Timestamp(max(UpdatedDateTime))
Comments (Dimension) = Comments