how to group attribute

​@SandyA You’ll probably have to add CSAnswers table and join it in to be able to group on it.

​@BenjaminCrisman  so I did add the CSAnswer table but I still can’t find it in the grouping

Hi ​@SandyA ,

Adding to what ​@BenjaminCrisman said, when joining on the CSAnswers table you should also include AttributeID as another row on the relation, otherwise the query will return all of the attributes that are defined for the customer.  The  join would be Parent Field = ‘PARENTROLL’ , Child Field = CSAnswers.AttributeID and the grouping would be on CSAnswers.Value .  

Hope this helps!

Laura

​@SandyA 

Use the CSAnswers table as a workaround:

1. Add CSAnswers to the Tables tab.
2. Create a Left Join using:
   • Main table NoteID = CSAnswers.RefNoteID
3. Add another relation condition:
   • CSAnswers.AttributeID = PARENTROLL
4. On the Grouping tab, select:
   • CSAnswers.Value
5. In the Results Grid, use CSAnswers.Value instead of the virtual AttributePARENTROLL field.

​@mohammadnawaz51 

i did what you said.

it worked but i just got only one record

​@KrunalDoshi ​@BenjaminCrisman ​@lauraj46 ​@mohammadnawaz51 

thank all guys for you help