So I have an issue I am not positive how to solve.
I have a pivot table that is created from an OLAP cube that populates that pivot table in a sheet. I do not have access to the actual source tables from that database. There is a field in that database that is not existent, so I want to link it to a table that has it to create a join relationship to be able to pull in that field through the pivot as a field.
Is there a way to do this? I am not familiar if it is possible or not. I know how to do it from table to table in access/powerpivot, but since one is a pivot table from which I cannot access the source tables I do not know how to go about it.
I have a pivot table that is created from an OLAP cube that populates that pivot table in a sheet. I do not have access to the actual source tables from that database. There is a field in that database that is not existent, so I want to link it to a table that has it to create a join relationship to be able to pull in that field through the pivot as a field.
Is there a way to do this? I am not familiar if it is possible or not. I know how to do it from table to table in access/powerpivot, but since one is a pivot table from which I cannot access the source tables I do not know how to go about it.
