Do I need to write a user exit? or is there any other way to do this?

Hello BW Gurus,

I want my output to be like this:

Week dept item date qty

38/2005 1 A 10/15 10

10/16 30

10/17 20

-

38/2005 1 A 20 output

-

I want only this resulted column to be displayed. I can get 20 by selecting 'result = last' in the property but when I remove the drill down on date its giving me the Result as follows:

-

38/2005 1 A 60 (But I want 20 the last day of the count)

-

Is there any way to do this? or do i need to write user exir?

Please give your Ideas.......And thanks so much,

Lisa