3 Replies Latest reply: Oct 14, 2014 1:26 PM by Jonathan Poole RSS

    Using TOTAL to get % all Data

    Steve Zagzebski

      Below I have the data and result I am looking for. I can't figure out how to get the column: All Groups % of Total. This column takes  revenue by area for ALL groups divided by total revenue for all groups and all areas. (Example for "North"...All north revenue is 60 and all revenue is 360...thus it is 17%)

       

       

      DATE:
      GroupAreaRevenue
      1North10
      1South20
      1East30
      1West40
      2North50
      2South60
      2East70
      2West80
      RESULT
        (filtered on Group 1):
      GroupAreaRevenueAll Groups by AreaAll Groups % of Total
      1North106017%
      1South208022%
      1East3010028%
      1West4012033%
          100360100%