Multiple Calculations on Multiple Measures
Wednesday, April 28th, 2021
Suppose you want multiple measures in your view. No problem.
But suppose you want multiple calculations on those multiple measures, and you want the multiple calculations to all be in the same row. That’s what this post was discussing. The person wanted a view with a different measure in each row and a different calculation in each column. The view should look something like this:
Easy in Excel, but not so easy in Tableau! You can easily have multiple rows with multiple measures, but how to have this while also doing different calculations in each column? The only way I can see to do it is to first reshape your data. Your data probably looks like this:
But instead it should look like this, so that each metric gets its own row.
Once you have it reshaped, you create a couple calculations in Tableau:
And then create a view like this:
Here’s the data I used for this example.