Hi All, how to get metrics for the Total Count of transactions and Total Dollar Amount. Thanks!

saved search including internal ID and amount (transaction total). filter to main line so you only get one transaction per line. Do a little checking/refining on your own to make sure that's actually what you want (e.g. do you want to restrict to posted transactions, by a specific period, etc., etc.)

i want total transaction count and total dollar amount per subsidiary

Add a column Subsidiary then group by that column