How do i display MTD, QTD, YTD sum of Top 10 values of a category

[ttttttyyyy]

I tried to use this code for MTD Top 10 values of a category but I am unable to get the results. 

=Sum({<CUSTOMERGROUPNAME ={=Rank(Sum({$<AS_OF_DATE= {$(=max(as_of_date))}>}total_revenue))<=10})total_revenue)

[edwin]

are these two different fields?

AS_OF_DATE

as_of_date

[edwin]

or was it a typo?

[ttttttyyyy]

They are the same field

[ttttttyyyy]

I wanted to use the above formula to calculate current month MTD sum of Top values