2 Replies Latest reply on Aug 9, 2017 2:48 PM by Kevin Thorson

    How to display % of total when the components are more than 100%

    Kevin Thorson

      Here is an example of what I'm trying to do:

      In January there were 4 people who drank and 100% of them drank beer, 50% drank wine, 25% drank Vodka, and 25% drank rum.  In February 3 people drank and 67% drank beer and vodka while 33% drank wine.  I want to create a line graph that has the % of people that consumed Beer, wine, vodka, and rum each month.  The challenge I'm running into is that a table calculation (Percent of total, calculated Table (down)) takes a percentage of the total drinks not the percentage of people who consumed each beverage.

           

      NameMonthBeerWineVodkaRum
      JoeJanXX
      BillJanXX
      MaryJanXX
      SueJanXX
      MikeFebX
      HenryFebX
      KarenFebXXX