19 Replies Latest reply: Jul 13, 2016 5:49 AM by Gourav Sikka RSS

    Help

    Gourav Sikka

      Hi Team,

       

      I have a requirement.i have a data from 2000 to 2016.. i want to make stacked bar chart where i want to show in dimension field in year from 2012 to 2016..but in 2012 bar show sum of 2000 to 2011 Value in half bar .and other half bar 2012 value...same as 2013,2014,2015,2016 ..... for this  i am sharing excel where value from 2000 to 2016 ...kindly help me.

       

      Year            Id

      2000            1

      2001            2

      2002            3

      2003            4

      2004             5

      2005             6

      2006             7

      2007             8

      2008             9

      2009            10

      2010             11

      2011               12

      2012              13

      2013                 14

      2014                15

      2015                 16

      2016                 17

       

      When i select on 2012 then it show count of id from 2000 to 20111 in half bar ..other half bar show 2012 value like 13....same as 2013,2014