RATIO

[sagaraperera]

DEAR ALL

I want to get the relevant RATIO as mentioned  below. The required EXPRESSION is given below.

REG	MONTH	MO	2022	RATIO
F	05	MOTOR	21,572,659	A/T		A
F	05	NON_MOTOR	89,835,261	B/T		B
F	05	Total	111,407,919	T/T		T
M	05	MOTOR	75,337,371	A/T		A
M	05	NON_MOTOR	12,378,710	B/T		B
M	05	Total	87,716,081	T/T		T
			EXPRESSION= Sum ( {$<FLAG= {'Y'} >}[GROSSTOT])

[hic · Accepted solution]

It seems as if you want to get the relative numbers, i.e. divide by the total for the group. If so, you should try

Sum ( {$<FLAG= {'Y'} >}[GROSSTOT])
/
Sum ( {$<FLAG= {'Y'} >}total <REG,MONTH> [GROSSTOT])