How to create a BIP Report in excel with a drill down option?

Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and so on in a waterfall mode. Basically there is a data model under another one to be called after clicking on a specific field.

How can I do it?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

24A

Code Snippet (add any code snippets that support your topic, if applicable):