Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Display key figure

Hi guys,

I work on an infocube in which we have for example :

ID : 1 creation : 01/02/2007 result : ok keyfigure : 7

ID : 2 creation : 17/02/2007 result : ok keyfigure : 7

ID : 3 creation : 21/02/2007 result : not ok keyfigure : 7

ID : 4 creation : 12/03/2007 result : ok keyfigure : 3

ID : 5 creation : 13/03/2007 result : not ok keyfigure : 3

ID : 6 creation : 15/04/2007 result : ok keyfigure : 12

So for each record created the same month, the key figure is the same.

But in the Bex, i have to display like that (for example) :

month 02/2007 result ok keyfigure 21

month 02/2007 result not ok keyfigure 21

month 03/2007 result ok keyfigure 6

month 03/2007 result not ok keyfigure 6

month 04/2007 result not ok keyfigure 12

month 04/2007 result ok keyfigure 12

But i don't want the "sum".... i would have this thing :

month 02/2007 result ok keyfigure 7

month 02/2007 result not ok keyfigure 7

month 03/2007 result ok keyfigure 3

month 03/2007 result not ok keyfigure 3

month 04/2007 result not ok keyfigure 12

month 04/2007 result ok keyfigure 12

I created 2 kf for resolve this problem : one with aggregation 'SUM', the other one with aggregation 'MAX'.

But it doesn't work.

Thanks for help.

Points will be assigned.

Cheers,

Vince.

Message was edited by:

vince ricard

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question