on 04-15-2014 10:46 PM
Hello, I have a query regarding BEX. I have a same requirement like this thread:
http://scn.sap.com/thread/2054781
material plant ordqty
A p1 100
A p2 50
B p1 30
I want a new keyfigure to show
material plant ordqty ordqty(all plant)
A p1 100 150
A p2 50 150
B p1 30 30
I tried to follow what this was person did and success. but in my case it did not work. I did what Anindya told this person to do but SUMCT, GT or RT are not wokring at all. did i miss something?
Thanks.
Try like this :
Switch on the result row display for Material..Then create a new formula and put ordqty using the function SUMCT.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your feedback. I have tried all these things but still not getting the results. I have tried using the ref. char. for Plant as well as Material but nothing worked. I have my result rows on also for both characteristics. see mine is not exactly material and plant mine is Material and Vendor but requirement is still the same
Material Vendor Quantity
A 10023 10
A 10023 15
B 10041 100
I want this:
Material Vendor Quantity New column
A 10023 10 25
A 10023 15 25
B 10041 100 100
Thanks.
Please check the data properly:
How come you have same material and vendor combination in two different rows.Isn't that should get aggregated.
Check this help.sap link.
Data Functions (SAP Library - Business Intelligence)
Regards,
AL
I do not understand that why SUMCT is not working in your case.Make sure to switch on the result row display for the characteristic in rows.
Alternative approach:
Assuming you have Material and vendor in rows:
Make a copy of Quantity Kf--Drag and drop vendors from left hand side--Right click on it and apply constant selection.
This way also you will get the desired result.Tested on my system working perfectly.
Regards,
AL
Hi Venkat,
Your requirement is exactly like that thread. I feel you might have done some thing wrong in creating Formula(aggregation tab). You should select Plant as ref char.
I think you are expecting other plants also other than P1 and P2 in new KF. Am I right? That's why SUMCT is not working for you. SUMCT or any data function can only work with the data which is available in the report only. It cannot fetch from BW system separately.
Cross check again and let us know..
Regards,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
create the new formula for the order quantity -> hit the aggregation tab -> exception aggregation -> summation/total -> reference char -> plant.
if you perform the drill down and drill across one char ( material, plant )it will give the values.
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.