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?