Calculate Totals by Column Level / Dimensionality() for Column Level

[Richard1993]

Hello Qlik experts,

I am encountering the following scenario:

LOAD * INLINE [
Name, Month, WorkingDays, FTE
Hubert, 01,32, 1
Hubert, 01,32, 1
Hubert, 02,32, 1
Hubert, 02, 32 , 1
Richard, 01,32, 1
Richard, 01,32, 1
Richard, 02,30, 1
Richard, 02, 30 , 1
];

I have a pivot table that displays totals for rows and columns, and I'm able to get the totals for the row level.

With the following expression:

IF(DIMENSIONALITY()= 0, 
SUM(AGGR(SUM(distinct WorkingDays*FTE), Name, Month)), SUM(distinct WorkingDays*FTE))

However, I'm struggling to get the totals for columns. I know where the issue lies, but unfortunately, I can't find a way to address columns in the pivot table. Is there a function similar to 'Dimensionality' but for column level?

Regards,

[rubenmarin · Accepted solution]

Hi, yes, SecondaryDimensionality() it's the Dimensionality() for columns. You can check "If(SecondaryDimensionality()=0" to set a specific expression for column totals