How will the dependency data be incorporated into the data set? Will it be in the same data source or in a new table? If the additional data is in a separate table, will it be possible to create a table join between the tables? Depending on how the data is structured, the possible options to create the desired view may vary widely.
Would it be possible to upload a new workbook that includes the dependency data as well?