I managed to get closer to being able to answer the question by using pie charts and using the count of the "father living" dimension for angle, but this is unsatisfactory. It does show a difference in percentages, but separates the results to individual pies, making it difficult to be able to say anything beyond "they look different". I am still looking for a better solution.
1 of 1 people found this helpful
It looks like your main challenge at the moment is to create your % values to use as the basis of your analysis.
If you right click the COUNT([Father Living]) field when it is in the view and select 'Quick table calculation' and "Percent of total", you will get back a % value.
From the above it looks like you have experimented with quick table calc's previously but haven't had any luck. My assumption was that this was because it was calculating across the wrong dimension. By right clicking your COUNT([Father Living]) table calc, selecting 'Compute using' and then selecting [Father Living] you should be able to express this as a % making it easier for comparison.
Let me know if this doesnt work / doesnt achieve what youre after.
Thank you. It was indeed the 'Compute using' component that I was missing. When I had tried this earlier, I didn't have [Father Living] as a color mark, so I wasn't getting the break down, and it wasn't an option in the 'Compute using' menu.