Question:
Here is the actual business scenario.
I have 3 chars(Plant(0plant),Order(0Prodorder) and Shift(0wagegr)), 1 key figure Actual Activity1(0CONF_ACT1).
Report looks like
Plant | Order | Shift | Actual Activity
2000 | 156156 | 1 | 100
2000 | 154142 | 1 | 500
2000 | 156156 | 2 | 50
2000 | 165248 | 2 | 125
2000 | 154145 | 3 | 500
2000 | 156156 | 3 | 300
2000 | 165249 | 3 | 125
If you see the order number in above report,it is repeated in different shifts.
When I take the Total of Actual Activity I want to exclude the 100,50 and 300
i.e Total should be = 1250.
In other words If a order number is having values for ACTUAL ACTIVITY in more than one SHIFT we need to exclude that when i take the Total of Actual Activity.
I hope the information I prvided here is clear.
please let me know if you need more info about it.
Thanks a lot,
Bobby.
Answer:
Sorry Boby, URGENT is not allowed ,read basic rules.
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759