Grouping in Reports

[Nirmal_Giri]

@Suvrutt_Gurjar

I am working on generating quotation for customer for multiple equipment.
I have a parent table ‘Customer Details’ and child table ‘Quotation Details’.A customer can have multiple quotation details. Each row in Quotation details has columns such as [Part Code],[Equipment_Name],[List Price],[Qty] etc.

I am trying to generate a report for a customer with items from child table grouped by [Equipment_Name]. Something like this:

Expected Report Format

I read your post on Group By Reports and tried the same on my tables with changes. Your sample app works with one table and slice. Here, I am trying to generate report from parent table (Customer Details) and want to group the records by [Equipment_Name] from child table (Quotation Details). As suggested I have added the following VC to child table and slice:
VC [_RefEquipmentName]
INDEX((SELECT(Quotation Details[Row ID], [Equipment_Name]=[_THISROW].[Equipment_Name])),1)

VC[Related Equipment]
REF_ROWS(“Quotation Details”, “_RefEquipmentName”)

[SliceByEquipmentName]
IN([Row ID], SELECT(Quotation Details[Row ID], COUNT([Related Equipment])>0))

When I use the slice for outer loop, my entire table is repeated for as many times I have unique equipment name. Below is the image:

Report generated

Report Template

Could you help me out?

Thank you