2 Replies Latest reply: Jun 17, 2011 8:26 AM by candice ball RSS

    Column % to Total calculation in pivot table

      I have a calculated column (which is the total of column(1)+column(3)+column(5)+column(7)  labeled "4MthPlan"

       

      In a pivot table, I would like to show the % to total of this column "4MthPlan" to the total of "4MthPlan".  See example below of expected data.

       

      I have tried the following and none work.

      sum("4MthPlan") / sum (Total ("4MthPlan"))

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      sum(column(8) / sum (Total (column(8))

       

      Any suggestions?

       

       

      product4MthPlanLastYearPlan% TtlPlan%LY
      Totals1415435100%225.3%
      Travel50020035.3%150%
      Soft85022560.1%277.8%
      Access65104.6%550%