Calculation issue in BarChart QlikSense

[ismailk94]

Hi Community!

I am having an issue in a barchart.

As you can see in the picture, I need to be able to chose several titles (in this case I have chosen two titles) and my aim is to see how the weight is spread out on male/female.

The issue is that for each title (each color) I need the sum of the weights to be 100%, such that the sum of weight for each title is 100%. I think the issue might be in my calculation:

Sum({<
>}weight)
/
Sum({<
>} TOTAL weight)


Any ideas on how to fix this?

Regards,
Ismail