Group rows on some colums and use SUM

Question

I have a table defined in AX like follows:

I am trying to create an SSRS report using a query to create the DataSet and as Design - PrecisionDesign.

I got this until now:

with groupings :

I would like to visually replicate this query:

SELECT Country
    , City
    , FirstName
    , SUM(AGE)
FROM TABLESSRSGROUPING
GROUP BY Country, City, FirstName 

Resulting in:

Answer 1

You should only need to group once within the first Row Grouping.

In the Group Properties - group on [Country] then ADD [City] then ADD [Name]

Let me know if this helps