I would like to ask for some advice on how to use ValueLoop in Set Analysis. I have a synthetic dimension using ValueLoop and I want to use the values of this ValueLoop dynamically in the set analysis expression so as to get following result :
ValueLoop within Set Analysis might not work. To tell you the truth, I have never tried it, but from the looks of things, I don't think it will work. You will have to use Pick(Match())... to get this done.
Set analysis is a way to define an aggregation scope different from current selection. Think of it as a way to define a conditional aggregation. The condition, however, is in itself like a selection that is evaluated before the cube (the chart) is expanded. Hence, it is not possible to have a condition that is evaluated row by row.