7 Replies Latest reply on Jul 26, 2018 2:17 PM by swaroop.gantela

    Percent Change in Population from Year to Year

    Reid Walker

      Hey All,

       

      I would like to calculate the percent change in population of each individual state from one year to the next. Year is being used as a quick filter and the state dimension is on columns so a percent difference table calculations isn't possible, or at least as far as I've tried.

       

      Screenshot (9).png

       

      I would like the user to be able to filter through the years and each state show a percent difference in population from the previous year. I have a feeling this needs to be a LOD calc, but right now I'm at a complete impasse as what that calc may be. Any and all help is much appreciated. Thanks.

       

      -Reid