Group Metrics

Feb 18, 2015 at 10:20 PM
In the Vertices tab I have added a new column Amount (under Other column) and entered for each vertex a $amount. I have grouped my vertices by connected component.
Question: How to get a group total ?
In the group Tab, is there a way to add a 'Group Total' column that shows the group amount for each group (G1, G2, G3...) (ie sum of members value for each group) ?
Feb 18, 2015 at 10:45 PM

Thank you for the interest in NodeXL!

Perhaps this is a case in which Excel is the answer?

The =SUMIF() function does a good job of adding up the values associated with a particular label.
 See example #2:
But first we need to find a way to move the Group Vertices assignment to the Vertices worksheet, that requires another Excel feature =VLOOKUP().

Feb 18, 2015 at 11:16 PM
Thanks Eric for your prompt answer. That put me on the right track. thans again.