LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ericbrazis

I have a data set that has a column that is already a count and formatted as a double. I don't want to take a count of the number of counts, but rather want to sum up all of the counts similar to what a pivot table would accomplish.

Here is an example of what the data set would look like.

Product Color Count
Apple Green 3
Apple Red 2
Apple Green 1
Apple Yellow 4
Apple Red 3
Banana Yellow 1
Banana Green 4
Banana Yellow 5
Banana Green 3

Here is what I'm trying to get to

Product Color Sum
Apple Green 4
Apple Red 5
Apple Yellow 4
Banana Green 7
Banana Yellow 6


How do I go about summing the original data? Any help is greatly appreciated.


Thanks,
Eric

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

The Agg Ex node does just this. See attached.
Attachments:
AggEx.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ericbrazis

Thank you for the help! I knew it was something simple.