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.
