12 Replies Latest reply on Sep 2, 2014 7:01 AM by Burcu Y

    Analysis with an aggregated table

    Burcu Y

      Hi I recently started working on Tableau and have been struggling with the same problem with the data I have.

       

      Suppose I have a huge data model with a similar structure to the below where the values are aggregated and the time dimension is as below. I could create calculated dimensions or parameters to point to a specific column, but then I can't display all years. But what would be the best way to create a year dimension and to be able to get the result for that year.

       

      Or is it a must to convert this to a structure where there is one column for year?

       

       

      Country 2000 2011 2012 2013 2014
      USA 3.5 3.8 4.1 4.4 4.7
      UK 2.5 2.6 2.7 2.8 2.9
      Germany 3.1 2.4 1.7 1 0.3
      France 2.2 1.9 1.6 1.3 1
      Italy 4.2 3.5 2.8 2.1 1.4
      Greece 2.2 3.1 4 4.9 5.8