4 Replies Latest reply: Oct 8, 2012 8:30 AM by Avinash P RSS

    How To caluculate % in Pivot Table..

    Avinash P
      Hi All,

      I have 3 columns like source,Month,Amount.using pivot tabe i displyed Data like this

      oct
      xx 45
      yy 05
      zz 50
      GrandTotal 100

      Now i want Calculate The %month

      oct %oct

      xx 45 45/total
      yy 05 05/total
      zz 50 50/total

      Please Let Me know How to Do This.

      Thanks,
      Sri