Hi.
I have created a file which is the result of a one-to-many merging process. The merged data looks like:
Italy,5,Rome,10
Italy,5,Milan,8
Italy,5,Naples,7
UK,6,London,15
UK,6,York,4
UK,6,Bath,3

I want to create a Table view that sums data at the "country" level.
For example, in a Map view I want to select UK and show in my table:
6 (UK value) ,22 (the sum of 15,4 and 3).

But if I select both UK and Italy, I want my table to show:
11 (6 + 5), 47 (all cities added).

At the moment, if I create my aggregate at the "country" level, in my table I have 2 entries:
5, 25
6, 22

While if I don't aggregate at the country level, my table shows:
33 (6*3 + 5*3), 47.

What am I doing wrong?
Thanks