I think you want to make separate measures that give you the count of males, and the count of females, and the count of Asians, etc.
When you put dimensions on the sheet, Tableau's behavior is to nest them. It just is.
So make a calc called [Male].
IF [Gender] = "Male" then 1 END.
or if you have a [Male] dimension, do
IF [MALE] = "Y" THEN 1 END
One way or another, get a measure that has a 1 in the new calc if that row indicates "Male'. Then you use SUM([Male Calc]) to get the count you want.
Do the same for all the other characteristics.
Not certain I understand but is this the view you want
it so this is how it is done
your workbook is attached
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.
Superstore.twbx 362.1 KB
I really appreciate your time, Jim, in detailing your response to me; however I'm looking for a non-nested solution, which means Segment would have to go directly below Category and not nested within it. Thank you~
Thank you, Joe. So I would have to make 10+ Calcs converting the values of each var to a 1 or 0 value? Then I should be able to list them on under one column?
Given the description you have in your first post, that would be my approach.
you can get any number of measures to line up in separate rows so you can report them by year as you show in your original post.
Sheet 2 in the example shows how to mix and match counts from different dimensions. You can see that you can add as many such measures as you want into the Measure Values shelf.
Superstore A.twbx 367.7 KB