3 Replies Latest reply on Jun 22, 2017 2:15 PM by Ron Bayes

    Exclude Group Dimension In Table Down Sum

    Ron Bayes

      I have a list of departments that are in a group.  Some departments  I do not want shown individually on my worksheet and are grouped together under the name 'Exclude' while the rest are appropriately listed.  I'm trying to calculate the % of total of all the departments listed on the worksheet except the 'Exclude' group.  The 'Exclude' group has to remain on the worksheet as I have other data points that are relevant.  In Excel terms, I have a table A1:J20.  I want to take the sum of E1 and divide that by the sum of E1:E19 to get the percent of total (E20 would be the 'Exclude' group that I do not want in the calc).

       

      Any thoughts as to how I would set this up?