Join us in Las Vegas on June 13-16 for the Snowflake Summit

Learn More
Get Started Transforming Your Data in Snowflake

How do I calculate ratios using the data in two columns to create a ratio in Tableau?

  • Tableau FAQs
  • December 13, 2018

This is a fairly simple function to perform in Tableau, and to implement it, you need to use the following expression:

SUM([SalesQuota])/SUM([SalesYTD])

From 1 Week to 1 Hour!

Build Data Models Faster in Datameer Than in Tabelau Prep.

Try Free Now

SUM([SalesQuota]) – here, you summarize the value of field A
SUM([SalesYTD])
 – then you divide the sum of values from field A by the sum of values from field B


Up Next:

Read How to alter the selected column value based on the value of another column in SQL?

More Resources We Think You Might Like

Tableau Questions

Can you create a process flowchart normally bui...

You can create a process flowchart in Tableau that is normally built in a tool like Visio. You wi...

  • Tableau FAQs
  • December 11, 2018
Lots of falling red and white dice with question marks on the si

Strengths and Weaknesses of Tableau Desktop

Tableau Desktop is one of the most common tools used by analysts. We will explore some of the adv...

  • Datameer, Inc.
  • July 12, 2020
Tableau Questions

What is the easiest way to make a calculation w...

This post answers how to calculate with a random group of orderid’s in Tableau. This functi...

  • Tableau FAQs
  • December 11, 2018