
1. Re: Using Tableau Calc Results in Other Calculations
pooja.gandhi Sep 29, 2016 1:14 PM (in response to Meghan Kyle)1 of 1 people found this helpful 
2. Re: Using Tableau Calc Results in Other Calculations
Meghan Kyle Sep 29, 2016 3:32 PM (in response to pooja.gandhi)Thanks for the reply!
Hmmm I can't quite get it to work on my side. When I create the DIFFERENCE calculation is does the difference before the running total table calc. I see your DIFFERENCE calculation has a table calc icon on it. Are you doing anything after the calc is dropped on the Measures Value shelf?

3. Re: Using Tableau Calc Results in Other Calculations
pooja.gandhi Sep 29, 2016 3:56 PM (in response to Meghan Kyle)It has a table calc delta symbol because it is utilizing the running total table calc. Its hard to say what you are doing without actually seeing the workbook. If you can attach your workbook with the sample data, I am sure someone can assist.

4. Re: Using Tableau Calc Results in Other Calculations
Meghan Kyle Oct 4, 2016 11:45 AM (in response to pooja.gandhi)Thanks again for your help. I could recreate what you did if I recreate my data values in excel and then pull the excel table into Tableau. However it's not working against my data source and all of the other calculated fields I have in my workbook. I've opened a case with Tableau Support to see if they can help me. If we can find a solution I will post it here.

5. Re: Using Tableau Calc Results in Other Calculations
Meghan Kyle Oct 4, 2016 3:21 PM (in response to Meghan Kyle)Ok Tableau Support helped me isolate the step I was missing. This is what I ended up doing:
(1) Created a calculation called "Difference" with the following code:
SUM(Closing Balance)  RUNNING_SUM(SUM(New Customers))
(2) Dragged the "Difference" calculation to the "Measure Values"
(3) You will see the Table Calculation symbol appear. I then make sure to change the field to Compute using > Fiscal Quarter
Thanks again for your help!