AnsweredAssumed Answered

Repetitive Data -- Consolidate and Sum

Question asked by mrelzer on Dec 21, 2017
Latest reply on Dec 21, 2017 by mrelzer

This is a bit of a simplification of what I'm doing -- but if I can get this part working, I'm sure I can get the rest working.

 

I'm getting data similar to :

 

100   MAT1   10

100   MAT1   20

200   MAT2   0

200   MAT2   40

300   MAT3   5

300   MAT3   5

300   MAT3   5

300   MAT3   5

 

How can I get the data to (using the first two fields as the key -- I need to sum the third element):

 

100   MAT1   30

200   MAT2   40

300   MAT3   20

 

If it matters, it's coming from a database stored procedure (so the profile is a database)... I cannot change the SQL (it's providing transnational data, I need to get to "total"). I'm going to an XML profile.

Outcomes