Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
wkolbnik
Contributor
Contributor

GetObjectField with Dimentionality as index

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.

1 Reply
wkolbnik
Contributor
Contributor
Author

Hm..that strange but

$(=GetObjectField(Dimentionality()+1)) wonks fine