Then I dont get the expected value. I want the MarketSalaryLevels to get summed up like:
If marketcompany A: salary 50 000, weight: 50 %. Company B: Salary 40 000, weight 50 %. Then that avg expression should give 45 000.) Country and IPE are 2 dimensions that allways will be selected. Job function is a third dimension which also will be selected. (This column is hided until these are selected)
Any suggestions on how to correct the formula according to my expectations?