0 Replies Latest reply: Jul 24, 2013 4:17 AM by dc43f098-d7b0-4721-af3d-af1ee3b48e59 RSS

    Chart graph with multi values

    dc43f098-d7b0-4721-af3d-af1ee3b48e59

      Hi,

       

      I have this specifications and i don't know if it's possible to create the chart graph:

       

      For somes products, i need to have the sales count by salers in 3D stacked vertical bar for a specific month (defined by the users) and nearby each, the average of this value for the previous year.

       

      For example :

           Bikes

                Tom

                     01/03/2013 to 31/03/2013 : 12 sales

                     01/03/2012 to 29/02/2013 : 48 sales (average 4/month)

                John :

                     01/03/2013 to 31/03/2013 :10 sales

                     01/03/2012 to 29/02/2013 : 120 sales (average 10/month)

                Peter :

                     01/03/2013 to 31/03/2013 : 24 sales

                     01/03/2012 to 29/02/2013 : 95 sales (average 8/month)

       

           Cars

                Tom

                     01/03/2013 to 31/03/2013 : 2 sales

                     01/03/2012 to 29/02/2013 : 10 sales (average 1/month)

                John :

                     01/03/2013 to 31/03/2013 :1 sale

                     01/03/2012 to 29/02/2013 : 14 sales (average 1/month)

                Peter :

                     01/03/2013 to 31/03/2013 : 3 sales

                     01/03/2012 to 29/02/2013 : 23 sales (average 2/month)

      I would like have in order :

           - Vertical bar for bike (March) with value 46 (12+10+24)

           - Vertical bar for bike (Y-1) with value 22 (4+10+8)

           - Vertical bar for car (March) with value 6 (2+1+3)

           - Vertical bar for car (Y-1) with value 4 (1+1+2)

       

      Do you know if it's possible and if yes, how can i create it?

       

      Thanks