Hello, I want to seek on other solution that I can find on this forum. Let’s say we have a datatable and list of values, countries, rate and value. Table example is as below
Countries Rate Value
Malaysia-RICE 0.5 0.5
Malaysia-CHICKEN 0.5 1.2
Malaysia 0.7 3.0
Singapore-BEEF 1.2 2.5
Singapore-NOODLE 1.2 2.5
Indonesia-ROSE 1.0 2.0
I want the output datatable is as below, where it groups the (Group and Rate, where the rate needs to be the same) together and also total up the value. How can I make this process faster when we have whole countries from all over the world?
Countries Rate Value
Malaysia 0.5 1.7
Malaysia 0.7 3.0
Singapore 1.2 5.0
Indonesia 1.0 2.0