
1. Re: Calculation logic when using countd
Jim Dehner Oct 13, 2017 7:08 AM (in response to Sharad Adhikari)1 of 1 people found this helpfulHi
I am on a different version of tableau and you would not be able to open the workbook
There are 3 foruma  see below
The overall result is this  note the Total is a Tableau function on the Analytics tab
Place state on rows to gewt the state level
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

2. Re: Calculation logic when using countd
Sharad Adhikari Oct 14, 2017 6:43 AM (in response to Jim Dehner)Hi Jim,
Thanks. I got the idea. Just to ensure that the second formula with Fixed was for calculating total of all Segment customers right. Should we use other formula so that we can calculate the total without Home Office?
So the second measure should show total excluding Home office. Is there a way to achieve that?
BR
Sharad

3. Re: Calculation logic when using countd
Sharad Adhikari Oct 14, 2017 6:58 AM (in response to Jim Dehner)Hi Jim,
I figured it out with if clause,
IF [Segment]= "Consumer" OR [Segment]= "Corporate"
THEN
{ FIXED : COUNTd([Customer Name])}
ELSE
NULL
END
I am still wondering why we it is difficult to solve this the overall issue with simple calculation and not using LOD.
BR
Sharad