Groups and Group totals in Paginated Report

Question

I am working on a Paginated Report by using data source as Power BI dataset. I was trying to create group on below columns and add the totals to each group.

1. Vendor
2. CategoryCode
3. SubCategoryCode

Problems in current Report.

1. Totals is not correct
2. Groups is not properly coming.

My current Report:

If you see above image, grouping is not happening at category code and sub category code level and total of amount also wrong. I need below output.

Output I need:

I have added Parent Group as Vendor and added Child Group Category Code and another Child Group Sub Category Code. I have added a Group Total for each group.