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

# Aggregated growth

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?

• ###### 1. Re: Aggregated growth

Hi Miles

please check this or you are looking for different scenario ?

right click and create a calculated field growth .

• ###### 2. Re: Aggregated growth

Before I can calculate that field (employment 2015 -employment 2010) I believe I first need to calculate the total employment in 2010 and 2015. How can I do this?

So far I have "calculated" the total employment per year by using filters or by putting years in rows. This is not sufficiënt for these calculations.

I am looking forward to hearing from you.

• ###### 3. Re: Aggregated growth

By accident I clicked on the button that states this question has been answered. How do undo this?