Creating a Module Report but need to bring detail
I hope you can help me with a step I am struggling with.
I have Module that have 4 years "Raw Data - Module: Data 00 - All T&E" for Transaction detail (using an Index as a list) and it has many items such as Vendor, Periods, BU, Functions, Account #. And as I need it for reporting purposes, I have bring the Lists with FINDTITEM or Parents, so it can be SUM.
Then as I need the Expense by Vendor, Function, Account and Business - I have created a Second Module and use SUM to bring the values.
Finally - We are creating a Dashboard with this information, where you can see your Total Expense by BU, Function and Account using the REP02 - Module. Then if you click in the Function, then it will bring you the list of vendors (all this works fine).
However, we want to be able also to bring the "Report Name" of that vendor which is store on the "Raw Data MOdule - DATA 00 - All T&E". One vendor can have multiple "Report name" because it is the description of the Transaction - The idea is to be able to click the "Vendor Name" from REP02 Module (once in the dashboard) and synchronized to bring the "Report Names" and the "Expense Associated"
Hope you can help me and point me in the right direction. Thanks!