bubble chart : country and areas at same level?

[#1]

Good morning

does someone know how to display in a bubble chart country and areas ?

The dimension is "Area". "Country" means the sum of areas.

I need to display in the same bubbles chart one bubble for each area and one for the country. Means i have to consider Country like an Area

Note there is only 1 country selected

best regards

christian

[johnw]

Let's say your data looks like this:

Country, Area
A, X
A, Y
B, O
B, P

I haven't tested this, but you could add a new table like this:

CountryOrArea, Area
A, X
A, Y
B, O
B, P
X, X
Y, Y
O, O
P, P

You should then be able to use CountryOrArea as your dimension to get both countries and areas in the same chart.