Group Metrics

Feb 18, 2015 at 11: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) ?
Thanks
Coordinator
Feb 18, 2015 at 11:45 PM
Hello!

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: http://support.office.microsoft.com/en-us/article/SUMIF-function-5fd078db-e5f8-4726-b08f-74fd0064e7fe
But first we need to find a way to move the Group Vertices assignment to the Vertices worksheet, that requires another Excel feature =VLOOKUP().
 See: https://support.office.microsoft.com/en-US/article/VLOOKUP-function-e2fba01b-188c-4057-87e2-df6bb4075817
Regards,

Marc
Feb 19, 2015 at 12:16 AM
Thanks Eric for your prompt answer. That put me on the right track. thans again.