I am building a worksheet looking at client commissions from multiple global regions. I have a dimension called client (which contains all clients), a dimension called region of trade (this contains, Europe US and Asia) and two measures, basis points paid and $cents per share received. Both of the measures are calculated fields using various other measures.
Within the same worksheet I want to be able to dispaly only $cents per share if the region = USA and only basis points paid if the region does not equal USA.
I cant think of an easy way to do this so I was hoping someone might be able to help.