Dimension name in a pivot table

[cdecluseau]

Hello all !

I try to know the dimension on each line in a pivot table, like this :

It looks great. Each total lines matchs with the right dimension level.

But if my table contains conditional expression for enable it, the result is (Example of add conditional expression for Market.Market1_Alias field) :

The second total line is now Market.Market2_Alias but the result of my function is Market.Market2_Alias. Unfortunately, I understand why.

Do you think there's a possibility to have :

Market.Market_Alias	Market.Market2_Alias	=Dimensionality()	=GetObjectField(Dimensionality())
zzzzyyyyxxxxx	zzzzzzz	2	-
	yyyyyy	2	-
	xxxxxxx	2	-
	Total	1	Market.Market2_Alias
Total		0	Market.Market_Alias

Thanks in advance for your help !

Christophe

[#2]

Instead of  Getobjectfield(dimensionality())  , could you use this expression -  if(Dimensionality()=2,null(),Getobjectfield(Dimensionality())   ..

[cdecluseau]

The problem is that GetObjectField() used Dimensionality() for dimension level and don't look at possible conditionnal dimension.

Dimensionality() = 0 remains for 1st dimension,

Dimensionality() = 1 remains for 2nd dimension,

Dimensionality() = 2 remains for 3rd dimension,

etc...

even if 2nd dimension is disabled.

[JonnyPoole]

i'm a little confused by the 2nd screenshot. there are only 2 dimensions instead of 3. What is the condition that you used ? possible to share a QVW sample ?

[cdecluseau]

That's my problem. I remove a dimension with a condition like 0=1. But the function =GetObjectField(Dimensionality()) don't look at that.