Forum Discussion
Solved
Drill Through Using Data From More Than One Table
Hello, I am working with educational data and have a report with data from many tables (enrollment, attendance, course grades, GPA...etc.). All of these tables share a "Student ID" column. My ...
I was able to get this to work by adjusting the relationships between my tables.
I have this same question. One table for all the distinct household ID values from my database, then "fact" tables with multiple instances of the household for stuff like geo information, assigned staff role, etc. I'd like to get a count of households by, e.g. Combined Statistical Area for a selected FUNDRAISERSORTNAME value. Do I just need to flatten all this?
@MarkPalmberg Exactly!
For my project, the ability to have high level reports on all the education topics I mentioned above with the ability to drill through to a single student page that contains data from each topic/table is critical. I'm hoping for a solution or workaround.