GETPIVOTDATA with PoverPivot hierarchies

[KatiaK]

For example, from the attachment, I want to be able to provide the full path of the hierarchy NAME. I get #REF error when trying to reference full path:

=GETPIVOTDATA("[Measures].[Suma cnt]";$B$3;"[Tabela1].[Name]";"[Tabela1].[Name].[surname].&[Kowalski].&[Emily]")

Is it possible?


Optionally, is it possible to use the CUBEVALUE function with a link to another excel sheet (without using sharepoint)?