Skip to Content
0
Former Member
Oct 15, 2006 at 09:03 AM

reporting profit margin

30 Views

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