Thanks, it works.
But, the games just get complicated.
Previously was single dimention, but now, i have second dimension across the pivot.
So, imagine vertical i have COMPANY | PRODUCT
horizontally, i have MONTH | WEEK.
and i need avg when both dimentions are collapse.
here is what i have done, but the avg is wrong...
=if(SecondaryDimensionality()=1 and Dimensionality()=1, avg(aggr( (sum(figure), WEEK)) , (sum(figures)))
Could you help ?