Hi Saggi, Please send one attachment. Please tell me How to use formula in pivot table in excel 2003?
Regards, Alisha On Fri, Apr 15, 2011 at 9:43 AM, saggi <realsa...@gmail.com> wrote: > Count of Divisions Poor Avg Good V Good > > Total Grand Total > Total Avg Avg Total > Total Good Good Total Total > Divisions V Good > BAWAL 1 1 3 3 4 2 2 2 6 > 6 > BHIWADI 3 3 3 1 1 1 4 > 4 > CORPORATE 1 1 3 3 4 > 4 4 > HPDC 1 1 3 3 4 1 1 1 5 > 5 > MANESAR 1 1 2 2 3 1 1 1 4 > 4 > Grand Total 4 4 14 14 18 5 5 5 > 23 23 > > > Generate pivot this way, Instead of doing count for Poor, good, Very > Good...just simple do count of Division. > > You can add formula in pivot too....go on "Option Ribbon"..then > Formula the Calculated Field > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
