3 Replies Latest reply on Jun 9, 2016 3:08 AM by Miles Copping

    Aggregated growth

    Miles Copping

      Hello everyone,

       

      I have only very recently been introduced to Tableau but I am already amazed by all its features. The features are so manifold that I have trouble finding what I am looking for. Hopefully I can get some advice on here.

       

      My dataset is made up out of firmyears (unique firm-year combinations). All firmyears include a value for employment, municipality, industry and year.

       

      ID

      Firmyear

      Employment

      Industry

      Municipality

      Year

      1

      Firm1

      20

      Education

      Municipality A

      2013

      2

      Firm2

      1

      Mining

      Municipality A

      2013

      3

      Firm3

      3

      Consulting

      Municipality B

      2013

      4

      Firm1

      22

      Education

      Municipality A

      2014

      5

      Firm 7

      88

      Consulting

      Municipality D

      2009

       

      What I would like do is analyse the municipality and/or industry employment development between two years. Preferable in a graph but a table would do for now as well. The table I am after would look something like this:

       

      Municipality

      Industry

      Employment 2010

      Employment 2015

      Growth 2010-2015

      Municipality A

      All

      561

      572

      +11

      Municipality B

      All

      200

      175

      -25

      Municipality C

      All

      33

      99

      +66

      Municipality D

      All

      240

      312

      +52

       

      My question is:

      How do I calculate the last column?

       

      In Excel I would use pivot tables for such calculations. In Tableau I believe I need to first sum all employment in municipality M in year Y with calculated field. Then do the same for a different year and finally compare the two calculated fields. I might be totally wrong however.

      Can anyone help me out?

       

      Thanks in advance,