5 Replies Latest reply on Jan 10, 2017 2:09 AM by Mikhail Galichenko

# YoY Growth

Hi! I've just sterted to use Tableau and have one qustion about YOY Growth.

I a dummy workbook I creted some data and trying to make YoY groeth rate. Thing I need help with are the following:

1) How can I make growth rate for corresponding months? Now I have 7th to 12th Months in 2015 and 1st to 12th in 2016 and growth rate is shown in 1st to 6th Month of 2016 (i guess it is based on 7th to 12th Months of 2016). How can I make it corresponding (i.e. 7th to 12th in 2016 compared to the same months in 2015)?

2) Is it possible to just choose one month in a filter (YY/MM format) and see growth from previous corresponding Month (if it exists in data). For example, from dropdown i choose September 2016 and I want to see YoY growth compared to September 2015. If I choose April 2016 I want to see nothin, because I have not got the corresponding Month in my data for 2015.

Mike

• ###### 1. Re: YoY Growth

Hi Mike,

You can start your journey on YOY calculation in Tableau here

• ###### 2. Re: YoY Growth

Mike,

1) To find the growth for a particular month from on year to the next, you can use LOOKUP function to create a calculated field. The calculation looks something like this:

2) In the attached workbook, I created a parameter that allows you to select the month that you want to compare. Then I created a dimension for the month name, using a DATEPART function to get the month number. I called this dimension "Month Name". That can now be used to create a boolean filter, where that month name must equal the month selected in the parameter. The final step is to duplicate the calculation shown above and change the -13/-12 to -1 and you should be good to go.

Hope this helps.

Sean

• ###### 3. Re: YoY Growth

Thank you very much, Sean. It really helped a lot