Hi,
I have created a Key figure with exception aggregate as Last value with reference char as order.
I have data like
Ord date KY KY2
01 ... 22 221
01 ... 22 223
02 ... 23 234
I want to get in the query KY= 22 for Ord=01 but i am getting KY= 44.
The exception aggregate is not working. IS there any other option.
Thanks,
Joseph M