I have a table with all sales detail for the past 3 years (more than 250,000 records) and I'm moving it to SQL server But When i try to create a view to query lets say total sales by Partnumber I would do it like this localy


select part,sum(qty) from sales group by part


but in the view builder for remote views the function sum() is not there.

How do you do it?