Forum Discussion
Defined Named Cell doesnt work with pivot tables !!
Hi, Appreciate your help with something that is puzzling and now annoying that i cant seem to find a solution. i have a large pivot table with 10,000 rows in and so when i want to find an item i...
Since you work with data model I'd add measure like
Count Yes or No:=COUNTA( Table15[Yes or No] )and use
=CUBEVALUE(
"ThisWorkbookDataModel",
"[Table15].[T col].[,exch no ind]",
"[Table15].[Yes or No].[loss]",
"[Measures].[Count Yes or No]")if with parameters it will be like
=CUBEVALUE(
"ThisWorkbookDataModel",
"[Table15].[T col].[" & $M$2 & "]",
"[Table15].[Yes or No].[" & $M$3 & "]",
"[Measures].[Count Yes or No]")
im sorry sergie, i dont follow.
i am trying to create a link that links text to a cell in the pivot table.
i dont know what the above does or where to put it, does it create a link ??
i am trying to create a link that links text to a cell in the pivot table.
i dont know what the above does or where to put it, does it create a link ??
I guess actually you don't need a link on abstract cell in grid within PivotTable, you need to return value for the combination of some fields.
Above formula returns Count of Yes or No for Yes or No = "loss" and T col = ",exch no ind". Actually it returns value in the intersection of above.
That's virtual link which uses PivotTable coordinates, not grid references.
Alternatively you may use GETPIVOTDATA(), it will be like
=GETPIVOTDATA("Level day",$A$9,"Yes or No","loss","T col",",exch no ind","Special","lev","POST","b2b")