cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
63

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hello Govind,

Its not a calculated key figure and that's the reason i could not find the summation option. So, do i need to write User exit? or is there anyother way to do this?

Please let me know and thanks so much,

Liza.

Former Member
0 Kudos

Hi Liza,

If you goto the definition of the Key Figure in RSA1. There is a tab called Aggregation. In that 'SUMmation' is chosen by default. Try to see if selecting one of the other options in the Drop-down helps you.

I don't think a customer exit is needed for this.

Check and let us know.

Former Member
0 Kudos

Hello Arun,

yes, you are right that its summating but where can i change this as i looked in properties but did not fine any option like this. Please can you walk me through this.

Thanks so much,

Lisa.

Former Member
0 Kudos

Hi Liza,

I guess that is a Calculated KF. If so, goto the properties of the CKF, at the left bottm, there is a button called 'Enhance'. Click that. You will see the 'Aggregaion' Drop-down which might have 'Summation'. Change that selection. Let us know if it helped.

Thanks

former_member184494
Active Contributor
0 Kudos

Liza ,

you might have to change the aggregation on your key figure quantity. Chenge it from summation. It is currently summation. That will let you get the latest value. Also you can change the result shown try setting result as overall result so that whatever dirlldown you do , the quantity value does not change.

Arun

Former Member
0 Kudos

Thanks for the reply but could you please explain me in detailed where I need to do this as I am new.

Once again Thanks so much,

Former Member
0 Kudos

If the dates are ordered you may get away with a TOP-N construction, where N = 1.