How to create a table report with group rows ?

[shaun1]

I need to create a report like as shown in the image.  The data source is an sql server with data mode as direct query. The result of the query repeats the rows for sales person and area for each customer. I need to group the rows by the sales person and area and have the data as the group header.  For each group row, the customer names and order amounts are the detail rows. The details rows need to be displayed by default and not as drill down. Such a format was possible in crystal reports. Is it possible with Power BI. I tried using table and matrix visualization types but couldn't do it 

[v-jiascu-msft]

Hi @shaun1,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft]

Hi @shaun1,

This visual looks very simple. What's the structure of your data mode? Can you share a little sample? 

BTW, if there is a hierarchy existed, the drill down is there by default.

Best Regards,

Dale

[shaun1]

This is the shape of my data in data mode. Also I need to accomplish the mentioned report structure without drilldown.

[Anonymous]

Hi @shaun1 ,

I have a similar requirement. Did the proposed solution work?

Thanks.

[v-jiascu-msft]

Hi @shaun1,

I'm afraid the Drill down is enable by default. The Matrix visual has the effect.

Best Regards,

Dale