Hi
Below is the data.
Based on this I want the below result;
The sale of Brand "cccc" should come only if "Onst" is included in the same invoice (like in the example). In some cases "Onst" will be missing. Which should be excluded from the result.
Any possibility without using VBA.
Thanks
Junarkar
Below is the data.
POS Receipt | Brand Desc | Article Type | Article Desc | Qty. | Net Sales | ||||||
BLC01805001234 | cccc | ZPPP | E-Elica Cooktop | 1 | 1,500 | ||||||
BLC01805001234 | Onst | ZXXX | EW- Cooktop | 1 | 201 | ||||||
Based on this I want the below result;
Brand | Sale | Qty | |||||||||
cccc | 1500 | 1 | |||||||||
xxxx | |||||||||||
yyyy |
The sale of Brand "cccc" should come only if "Onst" is included in the same invoice (like in the example). In some cases "Onst" will be missing. Which should be excluded from the result.
Any possibility without using VBA.
Thanks
Junarkar