
1. Re: Addition and Subtraction of Measures Values in Tableau
Zhouyi Zhang Jan 24, 2019 3:44 PM (in response to Ankur Gupta)Hi, Ankur
Please attach a sample workbook so that it will be easier for people to help
ZZ

2. Re: Addition and Subtraction of Measures Values in Tableau
Daniel Lawrence Jan 24, 2019 4:34 PM (in response to Ankur Gupta)Without having access to the workbook it is quite hard to nail down a specific reason.
My guess, however, is that your Distinct counts are summing over larger data sets and thus the grand total is taking into account the Distinct Counts before you segment them out. Meaning in the ones where you are off by 1 value, there may be an overlap between some of the categories that is thus not counted in the grand total.
A very similar instance occurred in this thread. My suggestion is to use LOD expressions to create your individual dimension values to negate this potential pitfall.
I would give an example but I can't see your dimensions to know what to FIXED, INCLUDE, or EXCLUDE.
Be very careful using Tableau's built in Row/Column Total functions, the more complex the calculation at the cell level, the less clear the level of granularity Tableau is calculating over.

3. Re: Addition and Subtraction of Measures Values in Tableau
Ankur Gupta Jan 24, 2019 5:53 PM (in response to Daniel Lawrence)Attached is the dummy workbook

DummyFile.twbx 112.2 KB


4. Re: Addition and Subtraction of Measures Values in Tableau
Ankur Gupta Jan 24, 2019 5:53 PM (in response to Daniel Lawrence)Attached data file

DUMMYWORKFORCEFILE.xlsx 96.9 KB


5. Re: Addition and Subtraction of Measures Values in Tableau
Ankur Gupta Jan 24, 2019 6:28 PM (in response to Zhouyi Zhang)I have added data file and workbook

6. Re: Addition and Subtraction of Measures Values in Tableau
Zhouyi Zhang Jan 24, 2019 6:58 PM (in response to Ankur Gupta) 
7. Re: Addition and Subtraction of Measures Values in Tableau
Ankur Gupta Jan 24, 2019 8:34 PM (in response to Zhouyi Zhang)A separate row with percentage using the formula i have mentioned above

8. Re: Addition and Subtraction of Measures Values in Tableau
Ankur Gupta Jan 24, 2019 8:34 PM (in response to Zhouyi Zhang)basically the percentage is TOTAL (calculated above)  Q4 Data/Q4 Data across all Job roles and total. We are trying to derive end of Q4 our numbers are so and so, then where are we with end of Q4 to now.

9. Re: Addition and Subtraction of Measures Values in Tableau
Zhouyi Zhang Jan 24, 2019 9:11 PM (in response to Ankur Gupta)Hi, Ankur
Can you first confirm that the total (206) is correct or not? this will help me to check whether my understanding is correct or not.
ZZ

10. Re: Addition and Subtraction of Measures Values in Tableau
Ankur Gupta Jan 25, 2019 12:15 AM (in response to Zhouyi Zhang)Hi,
Yes i tried that it works well. Thanks a lot for helping on that. It would be great if you can solve the way to get percentage as well.
Thanks for your help
Thanks,
Ankur

11. Re: Addition and Subtraction of Measures Values in Tableau
Ankur Gupta Jan 25, 2019 9:09 AM (in response to Ankur Gupta)Hi Guys,
I still need help on percentages. Its really critical. I really appreciate any help,
Thanks,
Ankur

12. Re: Addition and Subtraction of Measures Values in Tableau
Zhouyi Zhang Jan 27, 2019 4:53 AM (in response to Ankur Gupta)