Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have the following data for which I need to calculate Pallets Count (calculated as CartonCount devided by Units Per Pallet) but:
I managed to get the first and second item right but I'm unable to correctly calculate the Grand Total Pallets Count for orders containing multiple line with the same ItemCodes for a given OrderID - in the below screenshot the Grand Total row in the pivot table on the right should show 1 instead of 0,24.
The sample data can be downloaded from here: https://1drv.ms/x/s!AsndWCnO9mGupo4clejyLPORQfILEA?e=xasZ0e
Please explain this part
3886835503 | MY1W2AM/A | 84 | 850 |
3886835503 | MY1W2AM/A | 18 | 132 |
How can the unitsperpallet be different?
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |