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
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
Add a comment