Appending a calculation of data

[sblanchard]

I have 2 files, one that has a unique product with 100% total amount for a set of customers, and in another file that is a subset of those customers by product.   I want to append the difference in amount of each unique product from the total file to the subset file, and name customer as "Other Clients".  So the two files for that unique product, sum to the same total amount.  How do I do that?

[fmvizcaino]

Hi @sblanchard ,

I've created a simple dataset here, let me know if this is what you are looking for. 

Best,

Fernando Vizcaino

[Qiu]

@sblanchard 
It will be much better if you could provide us a sample input and output.