1 Reply Latest reply: Jul 9, 2013 3:26 PM by Stephen Redmond RSS

    % of Total by Month and Year

      I am trying to build a pivot chart in QV that gives me the % of the total column. Right now I have two deminsions present Yr and Month.

       

      Here is an example of what I am trying to do. I need to fill in the % of Deals column. (in July I would expect to see 50% for New and 50% for Upgrade)

       

      201020102010201020102010201020102010201020102010
      JulJulAugAugSepSepOctOctDecDecTotalTotal
      New / Upgrade# of Deals% of Deals# of Deals% of Deals# of Deals% of Deals# of Deals% of Deals# of Deals% of Deals# of Deals% of Deals
      New1-2-3-10-4-20-
      Upgrade1-4-9-1-6-21-
      Total2-6-12-11-10-41-

       

       

      Any help that could be provided would be great.

       

      Thanks

       

      Tim