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:
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:
INDEX((SELECT(Quotation Details[Row ID], [Equipment_Name]=[_THISROW].[Equipment_Name])),1)
REF_ROWS(“Quotation Details”, “_RefEquipmentName”)
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:
Could you help me out?