Difference between two measure totals in Tableau

Question

Using the sample-Superstore data, I am trying to do a table calculation on the row totals, Sum(Sales) -Sum(Profit). I can get the result using this formula

TOTAL(SUM([Sales]))-TOTAL(SUM([Profit]))

But it will also show the value under Ship date 2016/2017,(I only need the total). Any ideas on how to remove the highlighted portion or an alternate way to achieve this?

Answer 1

Try one of two: 1) Try right-clicking the column where your red box is, TOTAL(SUM(SALES))... and then un-check 'show headers'. That will remove the column from your viz, however the calculations and sorting will still be there.

2) Adding the measure-names manually, rather than with the 'measure names' blue-box in the columns. Then, right click the column you wish to hide, and uncheck 'show headers'. That will remove the column from your viz, however the calculations and sorting will still be there. .