SecondaryDimensionality Function

[Anonymous]

Hello,

I'm trying to SecondaryDimensionality function to know if the cell is the total one on a pivot table.

However the function max(SecondaryDimensionality()) doesn't work, always return 0 in every cell.

The max(Dimensionality) function works well.

In attach you'll see that SecondaryDimensionality() returns 1 and on the same cell the max returns 0.

Anyone one can explain this?

Thanks all

[Anonymous]

The problem is that max(SecondaryDimensionality()) always return 0, even when SecondaryDimensionality() returns 1 or greater

[#3]

Hi Ricado

Have you solve this issue?

I face the same problem Max(SecondaryDimensionality()) always return 0,

Rgds,

Alex

[Anonymous]

You can't use it like that, QlikTeck said max(Dimensionality) worked but just for luck.

Within Max function you need to have an array with values