Skip to Content
0
Jan 20, 2011 at 03:57 PM

Header level key figure value in item level reort

41 Views

we have a requirement to bring the header level PO value in to Item level ODS. Example, I f a PO has 3 line items with total PO value as 300$. We are getting the line item values as we are extracting by 2lis_02_scl.

But our requirement is to filter by total PO value in the report (Line item report). I think we can do this by put all the item level values in navigationa (free char) so that it will summarize by header value, Then I can create

a variable for the PO value. But I'm wondering if we can do this with adding the item level fields in the report by getting the total PO value in the ODS level it self ? Please advice

Thanks