I need someone to link 2 sets of data into 1 pivot or slicer excel spreadsheet has 3 tabs: BPD, Data Object Summary and Attributes. It is the Data Object Summary and Attributes tab that need work. In Data Object Summary tab, I would like to link it to Attributes tab, the link is SAP Target Data Object to Data Object. The objective is, in the data object summary tab, if i filter on the slicer the BPD, it will show me the SAP data objects associated with it and the attributes associated with that data object.
In the Attributes tab, if I filter on an attribute, it should show me to which data object it belongs to and to which BPD the data object belongs to.
Skills & Expertise RequiredExcel VBA
Microsoft Excel PowerPivot
Offer to work on this project closes in 115 days!Submit A Proposal
Share this project with your friends