Bubble chart

[Anonymous]

I have a bubble chart where agegroup is represented on the y-axis and number of pets on the x-axis and in the expression i have number of people/total number of people in order to get the precentage of how many peoples that have how many pets.

I would like the procent of the bubbles on the horisontal to add up to 100% but as it is now all the bubbles in tha chart sums up to 100%. Is there a way to get it like a want it to?

Thanks in advance!

//A.

[prieper · Accepted solution]

You need to include the dimension, which you wish to sum in angeled brackets, like

SUM(People)/SUM(TOTAL <Pets> People).

HTH
Peter

[Anonymous]

Thank you!

[Anonymous]

i have another issue about bubble charts: can i display values inside the bubbles? thanx