Hi Experts,
Webi Report showing , each customer has multiple documnet numbers (XBLNR) and amount wise.
i want to show take any one value of XBLNR as default value to show the total amount in the report.
want to show in the report as below show total amount for customer wise.
Customer name XBLNR OriginalAmount
Dana Holding Corp EXTHIST4 222017.03 (total amount of custmer for all XBLNR but show any one XBLNR value in report.)
use this in XBLNR COLUMN
=first([XBLNR]) in (customer name)
For next column use
=Sum(amount) in (customer name)
You already have an active moderator alert for this content.
Thank you very much AMit for your answer.I achieved it what you said
But to show particular XBLNR for each customer name then how to do Amit
Please help me thanks
You can not display the specific XBLNR for each customer name.you have option to show first or last or might be you can try with min/max function but these will not work properly with string data type object.
Add comment