2 Replies Latest reply: Dec 12, 2011 11:57 AM by Philippe Motillon RSS

    Bubble chart/Scatter chart (Advanced?) Multiple values for each dimension

    JOAKIM HAGERWALD

      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?

       

      If anything is

       

      Thanks in advance!