Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The problem is that max(SecondaryDimensionality()) always return 0, even when SecondaryDimensionality() returns 1 or greater
Hi Ricado
Have you solve this issue?
I face the same problem Max(SecondaryDimensionality()) always return 0,
Rgds,
Alex
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