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.
Creating calculated fields with if then logic could work. IF [region] = USA then [$cents] end and IF[region] <> 'USA' then [basis points paid].
This is hardcoding and it's not ideal but you could make one or two string params to pass to those fields so you could make the view dynamic.