14 Replies Latest reply on Nov 29, 2013 8:56 PM by Doug Stanley

    If 'this, then sum' and subtract from 'that...'

    Doug Stanley

      Relative newbie here. Packaged workbook attached. Thanks in advance for any help provided.

       

      I'm working with trade data for 38 named countries and the 'World'. I need to produce an aggregate value for the named countries, then subtract that from the World value (to prevent double counting) and ultimately arrive at a "Rest of World" figure that provides the correct bubble in the associated packed bubbles chart.

       

      I've tried multiple combinations of field calcs and groups. I get close, but not quite where I need to be. Driving me nuts.