Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You need to include the dimension, which you wish to sum in angeled brackets, like
SUM(People)/SUM(TOTAL <Pets> People).
HTH
Peter
You need to include the dimension, which you wish to sum in angeled brackets, like
SUM(People)/SUM(TOTAL <Pets> People).
HTH
Peter
Thank you!
i have another issue about bubble charts: can i display values inside the bubbles? thanx