5 Replies Latest reply on Jun 16, 2015 1:50 PM by Subha Narayanan

# Reference other sheets in table calculations?

Hi everyone, I'm new to Tableau so forgive me if this is an easy question... does anyone know how to write a table calculation across sheets? In my case, I'm trying to find the percentage of users who took a specific course but the data is set up in a way where on a separate sheet, there is the directory of users (some whom may not have taken a course at all) that I can use to data blend.

In other words, how would I count the (total users who attended course 101)/(total users) when (total users) is from another sheet?

• ###### 1. Re: Reference other sheets in table calculations?

Sheets don't contain data in Tableau like in Excel.

You can potentially recreate your total users calculation using Level of Detail. Can you please upload a Tableau Packaged Workbook?

1 of 1 people found this helpful
• ###### 2. Re: Reference other sheets in table calculations?

Hi Tom! Thanks for the response! Unfortunately, I'm not working with data that can be uploaded to the internet. Would you be able to point me in the right direction if I gave a simplified example?

For example...

Sheet 1

Email                               Course

someone@gmail.com     CR001

somehow@gmail.com     CR002

somewhere@gmail.com     CR001

Sheet 2 (Directory)

Email

someone@gmail.com

somehow@gmail.com

somewhere@gmail.com

whomever@gmail.com

anybody@gmail.com

How would I make a table that displayed that course CR001 has 40% (2/5) registration and course CR002 has 20% (1/5) registration. Currently, I am only able to blend the 2 data sets to show that CR001 has a 67% (2/3) registration and CR002 has a 33% (1/3) registration.

Thanks again for the speedy reply!!! I'm already looking into the level of detail function in Tableau to see if there is anything that can help me.

• ###### 3. Re: Reference other sheets in table calculations?

You can definitely make a sample file in Excel or similar and create a Tableau Packaged Workbook based on that.

Like I said, sheet's in Tableau don't contain data, data sources do. Create a sample and I'll take a look.

• ###### 4. Re: Reference other sheets in table calculations?

Tom,

Is this ok? The main point is that I potentially have more people in the "Directory" dataset than in the "Courses" dataset and I want to be able to show a table calculation that utilizes both.

And once again, thanks for the help!

• ###### 5. Re: Reference other sheets in table calculations?

Hi Tiffany,

When you connect to data source in tableau, if you are using an excel spreadsheet with multiple worksheets, pull in all the relevant sheets. Tableau will automatically join the data using the common fields. In your worksheet, you can create the fixed calculations.

Does this help?

Subha