I'm creating monthly reports using a variety of queries and I'm trying to understand the logic behind the drill down feature. I'm using RELATED to bring in all needed information into my main table, but the drill down is only displaying certain columns from that table. In my case, it is showing some columns I used for calculations, but leaving out some of the most important fields.

I have not found an intuitive way to control which of the fields are displayed in the drill down details. Is there any way to control which columns show up for the detail?

Thank you!