This discussion is archived
4 Replies Latest reply: Oct 8, 2012 6:30 AM by Avinash P RSS

How To caluculate % in Pivot Table..

Avinash P Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points