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,