Skip to Content
0
Former Member
Oct 01, 2013 at 10:28 AM

SAP BI Report

21 Views

Hi Experts,

In attached screenshots, i have forecast spend £12000 but because i did the lookup to populate PO No AND PO item and for one WBS Element there is more than on e PO no and for 1 PO no there is more than 1 item no. This forecast spend also repeated no of times in my cube. Now in the Report if i don't bring PO no and PO item then it will add and showing $756000 value. To show it correctly everytime need to bring PO no and PO item . but user don't want to bring PO no an PO item to see correct forecast spend. Please can you guide how can i restrict so it won't add up in report and will show only £12000.

Attachments

Capture.JPG (262.9 kB)
Capture1.JPG (33.6 kB)