3 Replies Latest reply on Feb 22, 2013 1:59 PM by Shawn Wallwork

    Calcuating Percentages when using Sets

    Timothy Stark

      I don't seem to be able to figure out how to calculate percentages properly when using sets.

       

      In the attached workbook I am using a set to sort product sales per company within a region.

       

      However, I can't seem to figure out how to properly calculate the % of sales within the region.  It works great without the set, but then I can't sort. 

       

      This must be fairly obvious.   I just can't figure it out. 

       

      Or should I be using Indexes somehow?