Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've data like this
LOAD * INLINE [
Prod, Val, Year
A, 10, 2014
A, 20, 2014
B, 30, 2014
B, 40, 2015
];
Now in st.table I'll take Prod as dimension, and I need to expression to get the values,20,40 for A,B. For A the max year is 2014 and the value is 20, for B the max year is 2015 and the value is 40.
How can I achieve this ?
Thanks,
Jagan
Expr: FirstSortedValue(Val,-(Year+Val))
I tried this but, I want to aggregate the value. B'coz I've lot values there
So far Prod A, expected output is 30(10+20)?
Exactly sorry for the mistake.
check this
Dim: Prod
Expr: SubField(Concat(Aggr(Sum(Val),Prod,Year),',',-Year),',',1)