3 Replies Latest reply: Oct 8, 2011 4:14 AM by Gabriel Grünberg RSS

    Making chart from yearly data

    Gabriel Grünberg

      I'm having a problem with a data set that I need to combine in different ways in QV.

      The problem is the data sources, I do not understand how I can make charts/pivots of this information.

       

      The data is year-based and looks like this:

       

      Country2001
      2002
      2003
      2004
      USA30555343
      Canada206723512
      England10454524
      France50584534
      Germany40763574

       

       

      How do I turn this "back" into something like this (or do I even need to?):

       

      Country
      YearAmount
      USA200130
      USA200255
      USA200353
      USA200443
      Canada200120
      Canada200267
      Canada2003235
      Canada200412