Question: I need a report that shows only active agents production for the last 12 months.
Answer: Agent status isn't stored in the same area as agent production, so a report that includes only active agents isn't possible. You can use the YTD Production report to see calendar year & fiscal year production by agent. However, the Agent Recap report will probably be best as it totals active agents at the top then has removed agents at the bottom. You can sort this report by descending volume YTD or by name.