count of rows in a pivot table

[ali_hijazi]

Hello

I got a pivot table with 3 dimensions Country, Compentency Gap, and Employee ID

and an expression with the definition : Only(EmployeeName)

now what I want is to display the total number employees on per each value of the dimensions

the partial sum doesn't return anything since the expression is string

how can I force the pivot table to display by the partial sum the total number of rows?

Please advise

[Gysbert_Wassenaar]

Try using count(EmployeeName) instead

Or if you want the employeename at the detail level: if(dimensionality()=3,only(EmployeeName),count(EmployeeName))

[ali_hijazi]

well yes but not 100%

I have to write the dimensions in the aggr function if I want to see the total at each additional level of dimensions

for example I added 3 dimensions now EmployeeCountry, CompetencyGap and EmployeeNo

if(Dimensionality()<=2,count(aggr(Count(FullName),EmployeeCountry,CompetencyGapValue,EmployeeNo)),Only(FullName))