2 Replies Latest reply on May 24, 2016 5:57 PM by jules.greenidge

    Excluding dimension contents from grand total

    jules.greenidge

      Hi,

       

      I have attached a relatively simple Return on Investment (RoI) calculation (i.e. total revenue divided by total cost) for various fictional salespersons within various fictional sales regions. I can calculate RoI by region, but what I would like to see is what impact each region is having on the overall RoI.

       

      For example, when all sales regions are included, the total RoI is 1.26. When the 'West' sales region is excluded the total RoI rises to 1.77, i.e. a difference of -29%.

       

      Ultimately I'd like to end up with a table that looks like this:

       

      Sales RegionRevenueCostRegion RoIGrand Total RoI excluding RegionImpact of Region on Grand Total RoI
      Central£249£1012.471.1410%
      East£249£1701.461.223%
      North£410£1952.101.0816%
      South£337£2381.421.214%
      West£175£4270.411.77-29%

       

       

      Thanks in advance for your help!