I'll try to explain better what I want with this expression:
Let's say this dimension is called Office. If AllocTransfOrigMarketCd is not mentioned on any match function of Office definition, the name of the group of that field in the dimension Office should be its correspondent AllocTransfOrigMktDescrip.
For example, as AllocTransfOrigMarketCd= 10 is not mentioned, it should be include in a group called PORTUGAL because PORTUGAL is the AllocTransfOrigMktDescrip for AllocTransfOrigMarketCd= 10.
This expression works pretty fine when I'm using a pivot table with simple measure.
The trouble starts when I'm using and agregatte function as a measure in a pivot table.
For example, I have this measure in a pivot table:
Wich means I'm calculating relative weights by aggregating value by AllocTransfOrigMktDescrip.
If I use AllocTransfOrigMktDescrip as a row dimension, everything goes fine… but if I use the calculated dimension "Office", QS shuffles and output something like the image attached.I think that's because I aggregate the measure by AllocTransfOrigMktDescrip… Does anyone know what I can do better?