Hi all,
I know there are some answers to this predicament on here but want some more clarity.
I have a file that is 1 GB full of sales transactions, however I just need to sum up all the repeating UPCs into one sum total. Sample size of an example of how the data is displayed.
| UPC | DESCRIPTION | FAC CODE | REGION | ENTITY | QTY SHIPPED |
| UPC1 | UPCDEC1 | ATL | SO | ENT1 | 1 |
| UPC1 | UPCDEC1 | ATL | SO | ENT1 | 2 |
| UPC2 | UPCDEC2 | SAR | FL | ENT2 | 3 |
| UPC3 | UPCDEC3 | ATL | SO | ENT2 | 4 |
| UPC2 | UPCDEC2 | AUR | RM | ENT1 | 5 |
I need in theory to output, UPC1>UPCDEC1>ATL>SO>ENT1>1+2=3
So on and so forth. But I also need to output the same thing but the total of ENT2 separately so I DONT want that in the total for ENT1. Preferably that to output in another column on the same total row.
I'd like it look like the below:
| UPC | DESCRIPTION | FAC CODE | REGION | ENTITY1 | QTY SHIPPED SUM TOTAL 1 | ENTITY2 | QTY SHIPPED SUM TOTAL 2 |
| UPC1 | UPCDEC1 | ATL | SO | ENT1 | 3 | ENT2 | 0 |
| UPC2 | UPCDEC2 | SAR | FL | ENT1 | 0 | ENT2 | 3 |
| UPC3 | UPCDEC3 | ATL | SO | ENT1 | 0 | ENT2 | 4 |
| UPC2 | UPCDEC2 | AUR | RM | ENT1 | 5 | ENT2 | 0 |
Any help would be appreciated thanks!
