9 Replies Latest reply on Jul 20, 2016 3:49 PM by Derek Wong

    Grand total and percentage columns

    Melissa Fanucci

      Hi all,

       

      Newbie here. I've searched the knowledge base and the forums for various answers on determining percentage of totals, but still haven't managed to figure out how to make the chart look like I want it to.

       

      Its this simple:

        

      MonthCarTruckTotal% Car
      Jan6446742625067092496%
      Feb6368472285465970197%
      Mar7619382405578599397%
      Apr7508112422777503897%
      May8019002916083106096%
      Jun7950462514682019297%
      Jul9227392993195267097%
      Aug9558782894898482697%
      Sep7821872822181040897%
      Oct7045882652073110896%
      Nov6717292588269761196%
      Dec7133892407073745997%

       

      Yet apparently I can't figure it out.   I've tried adding a grand total from the Analysis-Totals option but can't figure out how to also make a percentage next to it. I've also created a measure totals using:  for window_sum(sum([Volume])).  But I can't make that next jump to having a simple percentage column showing the percent of ONE of my modes (car, not truck).

       

      Apologies for repeating a  commonly asked question, but after 2 hours of reading community posts I'm still no closer. Thanks for any help!

       

      Melissa