OLAP Pivot Table and Cube Fuctions

[Guinaba]

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?

 

[RoryA]

I don't really understand what you are trying to achieve; presumably not just replicating what is in the product group column currently (as you could use a simple cell link for that)?

 

[Guinaba]

I don't really understand what you are trying to achieve; presumably not just replicating what is in the product group column currently (as you could use a simple cell link for that)?

I want to add comments in the cells and link them to the product group column in the pivot table, but if the Product A moves from to another row into the PT, my coments should move together.