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.
Shawn, thanks for the reply. I don't think it's only a grouping exercise, although that may be part of the ultimate answer.
I have 38 named countries, each with a corresponding value, and 1 World value.
My need is simple but has stumped me to this point: List each of the 38 countries and a corresponding value. Calculate and display a "Rest of the World" value by subtracting the sum of the 38 from the single World value provided.
