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