Yes, the hope this get subtotals on each group according these family composition , thanks

See this graphic above this what I'm going for ..... Grouping by particular composition not just by subgroups of self, child...etc .... the composition of the family needs to defined and counted.

Yes, it would be helpful to have all variations but at least the top 10 variations defined and then the other could be grouped as "other"

1. Self 1x

2. Self / Child 1x

3. Self / Spouse / Child 1x

4. Self / Spouse / Child / Child 1x4. Seld / Spouse / Adult Dependent / Child 1x

5. Self / Spouse / Child / Child / Child 1x

5. Self / Child / Child / Child / Child 1x.

I would rather define on type not count, but count included in definition

1. 1 Self

2. 2 Self / Child

3. 2 Self / Spouse

4. 3 Self / Spouse / Child

5. 3 Self / Child / Child

....etc

Other

I solved this by fixing the "ID Family" and "FamilySizeGroups" ! Very happy with results

Tableau Public

Use the following calculated field to create the groupings by dimension

Thank you for your help!