% by category by year in scatter chart

[Anonymous]

Hello,

I have one chart as below:

It shows for each group, what is the % in total, and what is the % of female within that group. For example, for the biggest group (biggest dot), it accounted for 74% of the total population and 50% of this group is Female. 

I would like to see the trend for each group by year but after I put year as legend, the calculation of that '74%' becomes the % of total population but I would like this to be the % just for that year. 

The logic for those two measures are:

%GT Female = DIVIDE( sum([female]),CALCULATE(COUNT([id]),ALLSELECTED(table[group])))

%GT Payroll = DIVIDE( sum[id],CALCULATE(sum[id],ALLSELECTED(table)))

Thank you!

[dedelman_clng]

can you post some sample data?

[Anonymous]

up up thanks!