How to calculate subtotal in a straight table

[BoXiangWang]

Hi all,

I knew it should be an old topic, but after browsing some articles it is still not clear to me how to calculate the subtotals in a chart.

In my case as below, I want to let the Denominator become the sum of gender "F" and "M" of each month so that I can use it to calculate the percentage of females and males of each month.

For instance, the first row should be 53 / (53+12) since I want to have the percentage of females in Jan.

However, I don't know how to use set analysis with Total. Is there any references of ideas allowing me to achieve it without changing my data model? Thanks!

Numerator: =$(=v_ppl_count)

v_ppl_count: count(distinct Amount)

[Rohan · Accepted solution]

Try this.

v_ppl_count: count(Total<Month> distinct Amount)

Regards,

Rohan.

[BoXiangWang]

Thanks, it's what I need!