Top Selling Items In a Generic Inquiry

You could start with the SOLine table, group by InventoryID and sorty by OrderQty.  Additional filters could be used as necessary - such as order date and order status.

@Manikanta Dhulipudi : You can use the “Sales Profitability for Last 12 Months” GI, in best Case in a Dashboard widget as Acumatica provide it already for a quarter (Sales Manager Dashboard). There you have all values you need to build an overview your are looking for. Also you can copy the GI and add some result column e.g. qty of the Transactions

​@Manikanta Dhulipudi What did you update the Sales Profitability Analysis with to get quantity?