1 Reply Latest reply on Oct 31, 2012 11:35 AM by Kevin Hogan

    Worksheet Calculations and Filters

    James Blackburn

      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.


      Many thanks