I think it depends on your data structure?
What does the underlying data look like?
Thanks for the response!
It looks something like:
1, Person a, American, Smokers
2, Person b, Indian, Vegetarians,
3, Person c, Indian, Smokers,
4, Person d, Chinese, Vegeterians
5, Person e, Chinese, Non-smokers
My example shows a table that demonstrates how many items are in each category and that's very easy to do in Tableau. But how do I get the distinct row summaries in the same table? These are very easy to do in a separate table if I remove the 'trait' parameter and instead of count I use distinct count.
How can I combine both, so I both get the individual numbers, and also have a separate column that lists the number of distinct people who are American, the number of distinct people who are Indian?
I cannot remember which forum post I found this on, but there was a way for special calcs for summaries. And yay it is the first time I actually got it to behave
Have a look at the attached. Is that what you mean?
Smokers and Vegetarians.zip 26.4 KB
Thank you SO MUCH! This is exactly what I've been looking for and it solved my problem!