2 Replies Latest reply: Nov 30, 2009 7:10 PM by Jean-Jacques Jesua RSS

    Total on Pivot Table

    Jean-Jacques Jesua

      Hi ,

      I calculated percentage in a pivot table with the expression

      Count (Dc)/Count( All <Lib_TC , Flag_APC> Dc)

      I have 3 dimensions : Lib_TC, Flag_APC & Nb_SV.

      I'd like to add as a new column a total by row (= 100%)

      This my table result

       

      Lib_TCFlag_APCNb_SV01234Plus de 5
      1: < 500 hab.053,1%26,5%11,0%4,4%2,0%3,0%
      1: < 500 hab.112,4%24,6%22,2%16,2%9,4%15,2%
      2: 500 à 1000 hab.08,3%17,4%18,3%14,1%9,9%31,9%
      2: 500 à 1000 hab.12,4%9,7%16,2%17,7%14,9%39,1%
      Total30,1%18,3%10,8%6,7%4,6%29,4%

      Thanks for your help

      Jean-Jacques