Hi everyone. I'm new on Pentaho and I'd like to know if it is possible to build a drill-down report directly wih a query, not building a cube.

for example: I've got my query

select country, region, city, sum(amount)
from table1
group by country, region, city

and I'd like to get a report that allows me to drill between the different fields.
Could anyone tell me if it is possible and how can I do that?

THANKS a lot in advance.