Skip to Content
0
Former Member
Feb 20, 2009 at 11:08 AM

Query should fetch single value

14 Views

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