Hi all,
Previously I merger SAP_PPT_EV_ProductionOrderConfirmationAdd (3) with SAP_PPT_EV_MaterialDocument_TotalGR by production order to get the total GR and the table show as below. Do you have any possible formulation to get only 1 row of value for each production order after the merge process?
Currently with this data, I'm getting the wrong data since Powerbi will sum the Total GR / count the Total GR. Is there any way so that I can the right data which is not sum & not count.
SAP_PPT_EV_ProductionOrderConfirmationAdd (3)
|
| Production Order | Abnormality Category | Abnormality Quantity (M2) | Machine | Total GR |
| 100001709052 | C1_Scratch | 58.50 | 640 CH Machine | 10,368.00 |
| 100001709052 | C7.Moist.W | 87.00 | 640 CH Machine | 10,368.00 |
| 100001709052 | C7.Moist.W | 28.50 | 640 CH Machine | 10,368.00 |
| 100001709052 | C7.Moist.W | 18.00 | 640 CH Machine | 10,368.00 |
| 100001709052 | A5.Adh Line | 87.00 | 640 CH Machine | 10,368.00 |
| 100001709052 | O.Fluct.Mch | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Depr.Cst | - | 640 CH Machine | 10,368.00 |
| 100001709052 | O.fix.Mch.C | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Ind.Mch.Cst | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Preparation | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Handling | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Others | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Pwr.Cst | - | 640 CH Machine | 10,368.00 |
| 100001709052 | MP.Cst | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Depr.Cst | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Depr.Cst | - | 640 CH Machine | 10,368.00 |
| 100001709052 | Depr.Cst | - | 640 CH Machine | 10,368.00 |
