Hello, I hope I can get some help...
I have a measure in a chart (not script/coding) I want to calculate the sum of qty ordered units but cannot get the formula correct..
Using "sum(qty_ordered)" takes the full right column below to a sum of 13 but I only want it to calculate the sum of the item_type = 1.
Below I have an example of one (1) order which consist of several orderlines but its only the main product (in this case product "e" which shall be calculated as qty ordered).
Is there a formula to make this happen so the data only calculates the main product even though the full order consist of several other equipment (in a Measures chart)? I have tried IF and other formulas without a success..
Best regards
peter
| Product/equipment | Price | Item type | Qty ordered | order line no |
| a | 50 | 3 | 1 | 1 |
| b | 110 | 3 | 1 | 2 |
| c | 250 | 2 | 1 | 3 |
| d | 25 | 2 | 1 | 4 |
| e | 2500 | 1 | 1 | 5 |
| f | 10 | 3 | 1 | 6 |
| g | 75 | 3 | 1 | 7 |
| h | 375 | 2 | 1 | 8 |
| i | 500 | 3 | 1 | 9 |
| j | 40 | 3 | 1 | 10 |
| k | 1 | 3 | 1 | 11 |
| l | 100 | 4 | 1 | 12 |
| m | 30 | 5 | 1 | 13 |
