5 Replies Latest reply on Oct 4, 2016 3:21 PM by Meghan Kyle

    Using Tableau Calc Results in Other Calculations

    Meghan Kyle

      Hi Everyone,

       

      I am having a hard time figuring out how to use tableau calc results in other calculations.  I want to use an approach that doesn't involve me tweaking my model. I really want to find a way to resolve this within Tableau.

       

      I've put together a sample set of data and a step by approach outlining what I need. 

       

      Closing BalanceNew Customer $Running Total New CustomerDifference
      FY 2015Q1150,00050005000145,000
      Q250,0002500750042,500
      Q3335,0009008400326,600
      Q490,0001200960080,400
      FY16Q146,00080080045,200
      Q2123,00023003100119,900
      Q355,00080001110043,900
      Q459,0004001150047,500

       

       

      Step 1: I have determined the Closing Balance value by quarter

       

      Step 2: I have determined of the Closing Balance what portion is contributed to New Customers

       

      Step 3: I have created a table calculation : Running Total New Customers at the Level of Fiscal Quarter

       

      Step 4 [WHAT I CAN'T FIGURE OUT]:  I now need to take the Difference between Closing Balance and the Running Total New Customer. 

       

      I thought another table calculation might achieve this by doing Difference > Across but this option is not available....

       

      Any thoughts on how to achieve this?

       

      Cheers,

      Meghan