calculate a ratio

[srujanaponnuru]

the data is shown as below:

Group	COB_Quarter	Total	NSFR
ASF	Q1-2015	285081
ASF	Q2-2015	270959
ASF	Q3-2015	138554
RSF	Q1-2015	124366
RSF	Q2-2015	234002
RSF	Q3-2015	316566

the result I want is per quarter ASF/RSF in NSFR column

Please help me out.

Regards

Srujana

[Gysbert_Wassenaar]

sum({<Group={'ASF'}>}[Total])/sum({<Group={'RSF'}>}[Total])

[alexandros17]

It is better to rename the field Total into myTotal, then:

sum({<Group={'ASF'}>} TOTAL myTotal)
/
sum({<Group={'RSF'}>} TOTAL myTotal)