3 Replies Latest reply on Oct 15, 2013 5:52 AM by Matt Lutton

# Hello everyone, i'm a beginner in Tableau so please be kind to me

Hello,

I'm trying to do the following:

I have on Columns two Quarters of one year, on Rows, the value of sales.

Quarter 1     Quarter 2                     Result:           Growth

Value      10              15                                                     50%

I want to create another column where to see the percentage of growth, calculated using this formula:

[(Quarter 1 sale value / Quarter 2 sale value) - 1] *100

How can i do this using Calculated field?

Thanks!

• ###### 1. Re: Hello everyone, i'm a beginner in Tableau so please be kind to me

Tableau has built in "percent difference" calcs, so I don't believe you need to do this.  If you'll post a packaged workbook (.twbx file), someone here can set that up for you and show you how to utilize it for your data.

You can use the sample data provided to mock up a scenario, if your data is sensitive. Cheers

• ###### 2. Re: Hello everyone, i'm a beginner in Tableau so please be kind to me

If you attach a .twbx file someone on the forum could create the calculated field for you. Just go to File - Save As and change the "Save as type" to a packaged workbook and then upload it.

If you don't want to do that then check out this link from the On Demand Training and let us know some more about your data. For example, is Quarter the aggregate of Months, Days or is there literally a row in your data set for Quarter 1 Year 1. Those types of things will matter when answering this question.

Good luck!

• ###### 3. Re: Re: Hello everyone, i'm a beginner in Tableau so please be kind to me

Actually, I'll do the work for you.  See the attached.  I simply right clicked on the Sum(Sales) pill, and chose "Quick Table Calculation" > "Percent Difference".  In this view, it defaulted to the correct setup I wanted, but if your dataset is more complex, it can be modified to compute in a nearly infinite number of ways.

Here's a quick tutorial: Calculating Percent Difference Across Dimensions | Tableau Software

Welcome to the Forum!  This is a great place to learn.