Nested Aggregation

[#1]

Hello,

I am trying to achieve the below to fit into a single textbox, please give me your suggestions.

Fiscal Period	Country	=Num(FirstSortedValue( Aggr(Sum(PRC_USD_AMT),SLS_RPT_TRNS.INVC__DT,CTRY_NAM),-Aggr(DT_CONS_DIM.FISC_DAY_OF_MTH_NBR,SLS_RPT_TRNS.INVC__DT,CTRY_NAM))/1000000,'#,###,##0.00 M')
201610	Mexico	3.45 M
201610	Germany	11.96 M
201610	India	13.27 M
201610	US	33.92 M
	Sum	64.86 M

I want the Sum to be displayed in a text box. It is the Sum of Sales for the most recent date for each country.

please let me know if more information is needed.

thanks.

[#2]

This seems to work for me. Thanks Sunny.