Set analysis

[#1]

Hi !

I can t change the model, but i need to multiple in a pivot table a coefficient with using two different dimension for weeks

Is it possible ?

Thanks

Regards

[#2]

sorry it's not working, with this formula i allways have 0 😞

[#3]

last try for today (I'm leaving for the weekend)

sum({<Week={'$(=only(Week_S))'}>}Coeff)

sum({<Week_S={'$(=only(Week))'}>}Coeff)

Ciao

Klaus

[#4]

thanks for your help but it still not working

only() not working in set analysis ?

[#5]

did you try both expressions?

edited my last post and added another expression

Wish you all the best

Klaus

[#6 · Accepted solution]

ok, I use "if" instead of the set expression and it works

Thanks all for your help !!