2 Replies Latest reply on Nov 7, 2018 8:04 AM by Andrew Alcazar

    Finding the difference of two calculated totals after filtering

    Andrew Alcazar

      Hello, I am having trouble trying get this calculation work in my dashboard.

       

      What I am trying to do is find the difference between two calculated measures after filtering. So, what I did is create two calculations, one a fixed revenue that doesn't change and the other, a projected revenue, which dynamically changes as the parameters/filters change. What I want to do is: as I filter out the dates/change the parameter, I want to calculate the difference between the fixed revenue and projected revenue.

       

      I attached a tableau with fake data, but the same structure as my data.

       

      Thanks in advance for the help.