4 Replies Latest reply on Oct 14, 2016 6:31 PM by Benjamin Cole

    Calculated Field to Transform Data?

    Benjamin Cole

      Hi Everyone!

       

      I'm exploring this "World bank Data" data set found here.  I've already pivoted the data once in order to set up the years correctly.

       

      The Setup

      Below you can see a screen shot showing the dimension Series_Name, that segments GDP and Population.

      I'd like to show GDP and Population on the same graph, but because they are on such different scales I need to do a dual axis graph. 

       

      The Question

      How do I convert the dimension Series_Name into multiple measures, GPD and Population?

      Case Statement?

       

      THANKS!

      Ben

       

      Screen Shot 2016-10-12 at 4.21.22 PM.png