Compiling s String for Charting

[angelcause]

Hi I have a portal in which a field of AREA is setup, now the user enters different areas like :

id------activity------area------members-----guests

1------training------london-------4-----------7

2------visits---------china--------3-----------6

3------visits--------london--------5----------2

4------meetings----berlin--------6----------4

5-------meetings---china--------2----------5

Now I wan to make a chart in which I want to see area wise how many total members and guest I have. e.g.

Attached chart is an example created in Powerpoint

[IT_User]

I attached a filed that hopefully helps.

It includes Summary fields, SubSummary, and sorts.

Note: There will be two summary fields for the Y axis.

Chart.fp7.zip