Drilldown and Extracting Info


I am looking to build a report that allows drilldown into the line level detail of a given number from a summary sheet, but also allows you to view the invoices that are associated to the line level detail from dynamics. Is this possible at all?

As part of the same report, I have a pivot table that looks at purchase order information raised by a given person, but still requires a manual refresh of the purchase order data each month (albeit using the table builder function).


Any help would be appreciated.


Many thanks.


1 comment

Please sign in to leave a comment.