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

      James