
1. Re: How to create a calculated field of a calculated field? Or maybe a formula that could work.
subodh Thapliyal Mar 29, 2017 7:21 PM (in response to Alexandrina Biraltchanova)Hi Alexandrina,
In this case use table calculation fro running difference
Table Calculations for Advanced Analysis in Tableau
Hope this helps,
Otherwise attach a sample workbook here and I will try to find solution for this.
Regards
Subodh

2. Re: How to create a calculated field of a calculated field? Or maybe a formula that could work.
Jonathan Drummey Mar 29, 2017 7:28 PM (in response to Alexandrina Biraltchanova)2 of 2 people found this helpfulHi,
1) Drag the quick table calculation to Measures. This will create a calculated field and let you name it, fo it % of Total.
2) Create a new calculated field that is [% of Total]  LOOKUP([% of Total],1), call this Diff of % of Total.
3) Drag Diff of % of Total to Text.
4) Right click on the pill you just added, choose Edit Table Calculation and set the compute using for the nested calculation to be on Month or Table (Across).
I set up an example view using Superstore sample data:

3. Re: How to create a calculated field of a calculated field? Or maybe a formula that could work.
subodh Thapliyal Mar 29, 2017 7:34 PM (in response to Jonathan Drummey)Thanks Jonathan
for your valuable feedback.

4. Re: How to create a calculated field of a calculated field? Or maybe a formula that could work.
Alexandrina Biraltchanova Mar 30, 2017 7:19 AM (in response to Jonathan Drummey)Thank you Jonathan so so much! It worked!