Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (47.2k points)


I simply want to include a new column that shows the difference between 2017SU and 2016SU. Note that each of those two columns are a running sum.

I've tried doing a secondary table calculation but it does not add a new column.

1 Answer

0 votes
by (17.6k points)
  • Tableau views your data. I can't see what the full name of you numeric field starting with Seatc ...

  • Define three calculated fields:

    • 2016SU Seatc = running_sum(sum(if [Stc Term] = "2016SU" then [Seatc...] end))

    • 2017SU Seatc = running_sum(sum(if [Stc Term] = "2017SU" then [Seatc...] end))

    • diff = [2017SU Seatc] - [2016SU Seatc]

  • You'll have to set the partitioning and addressing (aka compute using) on the table calcs appropriately.

  • Finally, now you can use Measure Names and Measure Values to build a table (or other chart) using these 3 measures

That’s all for now. But, if you would like to learn more about Tableau, check this Tableau Training Course by Intellipaat. 

Browse Categories