reporting profit margin

[Former Member]

hi, i have problem with reporting of the hidden profit margin. I have a cube with data:

invoice number, inv.item, margin

1, 1, 250

1, 2, 250

1, 3, 250

2, 1, 10

2, 2, 10

2, 3, 10

i have problem displaying it in Bex, the result has to be:

1, 1, 250

1, 2, 250

1, 3, 250

result inv.1, margin 250

2, 1, 10

2, 2, 10

2, 3, 10

result inv.1, margin 10

result of all invoices 260

thanks for help

[former_member188325]

Hi,

Set 'Suppress Result rows' to 'never' for Invoice number and to 'always' for remainaning chars.

Set 'calculate result as' of Kefigure to ' average' or'max'...etc as per your requirement.

regards

[Former Member]

And if you put this option on your Key Figure :

- Calculate Result As ... Maximum ...

Isn't ok ?