Hi everybody.
I've got an issue. My data appears something like in the pivot table here below:
| Product Name | Product Component | Component % | Product q.ty | Components Q.ty |
|---|
| Product 1 | Component 1 | 30% | | 105 |
| Component 2 | 20% | | 70 |
| Component 3 | 50% | | 175 |
| | | 350 | |
| Product 2 | Component 4 | 80% | | 160 |
| Component 5 | 20% | | 40 |
| | | 200 | |
| | | | |
I've got the "Product Quantity which is obviously related to the product and not to its components, but i need to calculate the components quantity (Numbers in GREEN) base on a simple formula: product quantity * Component %.
The fact is that i managed to multiply the TOTAL * the %, but not the subtotal (which would obviously correspond to the product quantity as other rows are = to 0.
Do you have any ideas?
Even other ways to manage it at script level or somewhere else!
Thanks everybody in advance!!
