Hi!
I have pivot table with calculated dimentions
Calculated dimention text | Calculated value |
=$(=FirstSortedValue(Dim,Dim_ID,1)) | Year |
=$(=FirstSortedValue(Dim,Dim_ID,2)) | WeekNum |
Why
$(=GetObjectField(0)) returns 2017 and 2016
while
$(=GetObjectField(Dimentionality()-1)) returns "-"
How to get to work GetObjectField with Dimentionality as index.