Use of dimensionality in a pivot table

[Anonymous]

Hi everybody,

I have a big problem making an average column in a pivot table.

As soon as I use a set analysis in the sum column, I loose the last avg column:

Here, the second one seems ok, except it is not the avg but the sum I have in the last column. When I add any set analysis in the sum... I loose the last avg column...

//IF(Dimensionality() = 0, sum(sm.Nombre_Smart)/count(distinct MMM_YY), SUM({$<sm.Métier_SMART={'EPARGNE'}>} sm.Nombre_Smart))

IF(Dimensionality() = 0, sum(sm.Nombre_Smart)/count(distinct MMM_YY), SUM(sm.Nombre_Smart))

Any help welcome,