Hello Everyone!
I want to sum all rows depending on the ID. An example would be (See screenshot) sum all "Count" columns from ID 1 to one row, so ID 1 has 4 rows, each row has a 1 (highlighted in green) and the rest are 0's distributed on each column (See 1st table to understand more). The result I want is in table 2 which you can see is only one row but with the row sum combined so each column has a 1. In ID 2 you can see that only A_Count has ones so the result must be the ID 2 row with a count of 2 in A_Count, and the rest would be 0.
 

Can someone help me with this? What method should I use to do this? Hope I explained well.

Thanks!

Helo everyone!

I want to refresh DTC data but when I go through trailhead data manager and try to refresh an error occurs ups. Here's a screen shot of it:

Can someone help me fix this?