Pivot table and Cyclic Drill

[filder]

Hello everyone,

I'm trying to create a pivot table with two cyclic drills as dimensions. The problem is that if the user mistakenly sets the same field for both drills, the table throws an error and cannot be restored properly.
I tried using the getObjectField() function like this:

if(getObjectField(0)=objectField(1), 0, 1)

But it doesn't work.

Of course, I'm already using workarounds, but I'd really like to be able to use cyclic drills with the same fields just like it was possible in QlikView.
If it's a bug that will be fixed soon, it's enough for me to know that, and I'll just wait for the fix.

Thank you.

[filder · Accepted solution]

Hello Myself,

I have solved it using this:
=if(GroupDimensionLabel('Drill_1')=GroupDimensionLabel('Drill_2'),0,1)

[Lucke_Hallbergson]

It is being worked on already. PR exists