Bubble chart/Scatter chart (Advanced?) Multiple values for each dimension
Hello again forum!
I'm trying to make a bubblechart (Scatter chart) looking like this
Dimension:name
1. Sum({$< Year = {"2010"}>} Sold)
2. Sum({$< Year = {"2010"}>} numbers)
3: Sum({$< Year = {"2010"}>} amount)
and I would also want to display following for the same "name" 2009:
Sum({$< Year = {"2009"}>} Sold)
Sum( {$< Year = {"2009"}>} numbers)
Sum( {$< Year = {"2009"}>} amount)
I want to display all values for a name and year for 2010 as one bubble for each name. I want an aditionall bubble for values and name for 2009 in the same diagram (prefferebly with a line or arrow linking the two). I don't want to sum up the "numbers" from 2010 with the "numbers" from 2009. And I don't want to sum up the "amount" from 2010 with the "amount" for 2009. And I don't want to sum up the "Sold" from 2010 with "Sold" for 2009.
Is this something that is possable to make? And if so, how would I get this result?
