3 Replies Latest reply on Apr 28, 2017 9:19 AM by Ryan Rowland

    Best Calculation to Use - Select Amount Where dimension = X or Crosstab Format

    Ross Moffitt

      desired-result.JPG

       

      Attached includes an image of my data structure and my desired output. For each calculated column, I am just trying to return the Amount measure in a non-aggregated or summed way. Using an if statement doesn't seem to work, as it gives me a 0 for everything that is not found. What is the best calculation in Tableau to grab the desired result?  I do not what to create a cross tab, I want to create an isolated calculated measure for each scenario.

       

      Thanks!