I have configured 32-bit ODBC, and let my excel connect denodo views. I can pull the data from denodo to excel in detail level, how do I use microsoft query to do some aggregation caculation on some view. For example, denodo view_a (contain column month, cost), I want to do this:
select month, sum(cost) group by month
how to implement it through microsoft query?