How do I create an Interactive Report that shows multiple values from a table lookup field for a single grouping

[roby]

I’m trying to create an interactive report that shows sales by company. I want to group by the company field but in the report I want to display both the company name and company numeric code so that it shows both relevant values without nesting them at run time. Underneath the company grouping I then want to group by customer name.

I want the report to show a single row that shows Company Name, Company Number, and Total Sales Amount or the company. I can then expand the company and see the total sales amounts by customer.

[michael.w]

Group Rows by both Company and Customer. For Company, drag the entire Table Lookup field into the Group Rows box. This will allow you to select the related attributes of Company, including the company number, and display it in the row grouping

This also allows for expanding to see the next grouping at the customer level