Suppressing measures with OTBI report does not work
SummaryAny way to suppress measures while reporting with OTBI?
I have a requirement to report the Purchase Orders and the related vendors invoices in Procurement for a project. A Purchase Order can have several vendor invoices against it.
Here is how the report looks like with OTBI.
For the first case, PO # 10006523, there are two invoices, (INV 160, INV164). As all this information is reported from a single subject area, OTBI repeats the PO amount and PO Qty twice as there are two invoices. I included a calculated field on remaining PO amount and Qty, where the calculation goes haywire. However, at the PO number level totals, the values are fine. What I am looking for is two things: 1) how to suppress the PO amount and PO Qty from repeating? (these are both measures). and 2) How to suppress the calculated fields Remaining PO