So I have long list of products and customers that bought them
I'm trying to combine the customers who bought the same product multiple times. but only combine it PER product
I was able to group the products using KuTools format distinguish
So I have product grouped and a pagebreak between them kind of like below
I want to combine the companies that purchased multiple times for ONE product. So the end result looks like this:
As you can see. The Acme Inc purchases per individual product was combined.
If anyone can please let me know how to do this in Ku Tools I would be very grateful
I'm trying to combine the customers who bought the same product multiple times. but only combine it PER product
I was able to group the products using KuTools format distinguish
So I have product grouped and a pagebreak between them kind of like below
| Product Name | Quantity | Company Name |
| Apple | 10 | Acme Inc |
| Apple | 10 | Acme Inc |
| Apple | 5 | Microsoft |
| portocale | 25 | Acme Inc |
| portocale | 20 | Microsoft |
| portocale | 25 | Acme inc |
I want to combine the companies that purchased multiple times for ONE product. So the end result looks like this:
| Product Name | Quantity | Company Name |
| Apple | 20 | Acme Inc. |
| Apple | 5 | Microsoft |
| portocale | 50 | Acme Inc. |
| Organge | 20 | Microsoft |
| | | |
| | | |
| | | |
As you can see. The Acme Inc purchases per individual product was combined.
If anyone can please let me know how to do this in Ku Tools I would be very grateful
| Acme Inc |