This is because for the same client, it is in more than one project, status and substatus combination.
The grand total just looks at the overall dataset and does a distinct count of the clients.
E.G. FOR 1st For Care Limited, there are two projects associated with it:
So in your crosstab, it is counted twice, but in the grand total it will only be counted once.
Please use this calculation if you want the count to calculated for each project, status and substatus level:
Then use this field in your view:
You may want to also add your filters to context (as fixed calculations are calculated before dimension filters) - more information on LOD calculations here Overview: Level of Detail Expressions :
Thanks and please see the attached workbook. Other useful LODs can be found here: Top 15 Tableau LOD Expressions (Practical Examples)
Creative Vitality_v10.2.twbx 468.7 KB
Many, many thanks.
Hi @Sean Bain
Glad it helps, Please mark this answer as a helpful or correct answer to close the thread.