Guinaba
Board Regular
- Joined
- Sep 19, 2018
- Messages
- 224
- Office Version
- 2016
- Platform
- Windows
Hi guys,
I have this OLAP Pivot Table (below) and I'd like to link a cell from the sheet to the cell within the Pivot Table. Cell references do not change when the position of the underlying data changes. Based on that, is there any way to do this link? I thinking to use CUBEMEMBER("ThisWorkbookDataModel","[Consolidate].[Product Group].[A]"), but my pivot table has around 200 rows, not sure how could I do it automatically?
I have this OLAP Pivot Table (below) and I'd like to link a cell from the sheet to the cell within the Pivot Table. Cell references do not change when the position of the underlying data changes. Based on that, is there any way to do this link? I thinking to use CUBEMEMBER("ThisWorkbookDataModel","[Consolidate].[Product Group].[A]"), but my pivot table has around 200 rows, not sure how could I do it automatically?