How to avoid to many expressions with Dimentionality() ?

[aisolomatin]

Hi there!

I got Pivot table with 6 dimensions and expression, wich depends on level of Dimesionality().

Is it possible to make this expression simplier and combine all cases to one line?

Thanks a lot)

=Pick(Match(Dimentionality(),0,1,2,3,4,5,6),

     Avg(Aggr(1 - Sum(Val1)/Sum(Val2), myDate),

     Avg(Aggr(1 - Sum(Val1)/Sum(Val2), myDate, dim_1),

     Avg(Aggr(1 - Sum(Val1)/Sum(Val2), myDate, dim_1, dim_2),

     Avg(Aggr(1 - Sum(Val1)/Sum(Val2), myDate, dim_1, dim_2, dim_3),

     Avg(Aggr(1 - Sum(Val1)/Sum(Val2), myDate, dim_1, dim_2, dim_3, dim_4),

     Avg(Aggr(1 - Sum(Val1)/Sum(Val2), myDate, dim_1, dim_2, dim_3, dim_4, dim_5),

     Avg(Aggr(1 - Sum(Val1)/Sum(Val2), myDate, dim_1, dim_2, dim_3, dim_4, dim_5, dim_6))

[woshua5550]

can you provide a sample app? I'm not quite clear how it works