# Orders by amount

[set first_done][/set] [search-region more=1 search=" ra=yes st=db fi=transactions ml=999999 tf=total_cost to=nr "]
username | total_cost | lname | city | state | email
--- | --- | --- | --- | --- | ---
[search-list]
[page href="config/edit_record" form=" mv_action=return mv_data_table=userdb mv_arg=[item-data transactions username] "][item-data transactions username] | [page href="config/edit_record" form=" mv_action=return mv_data_table=transactions mv_arg=[item-data transactions code] "][filter op=|'commify'| interpolate=1][item-data transactions total_cost][/filter][summary name=total.transactions.total_cost hide=1 amount="[item-data transactions total_cost]"] | [data table=userdb column=lname key='[item-data transactions username]'] | [data table=userdb column=city key='[item-data transactions username]'] | [data table=userdb column=state key='[item-data transactions username]'] | [filter op=|'mailto'| interpolate=1][data table=userdb column=email key='[item-data transactions username]'][/filter]
[/search-list]
TOTAL | [filter op=|'commify'| interpolate=1][summary name=total.transactions.total_cost total=1] [/filter] |  |  |  |
[/search-region]