A data analyst working with Databricks SQL has developed a query to analyze various key metrics for an e-commerce business on a monthly basis. These metrics include the number of orders, repeat customers, total revenue, and profit across different geographical regions. The analyst aims to dynamically view results for specific states based on selection. What is the most efficient method to achieve this?