Hi Members, Could you tell me where I should put the .Calculation = xlPercentOfColumn .NumberFormat = "0.00%" to get desired results
'Define fields in PivotTable With PT ' Reference to Exisiting Pivot Table With .PivotFields("HHSizeGroup") .Orientation = xlRowField .Position = 1 End With With .PivotFields("Q4_Community") .Orientation = xlColumnField .Position = 1 End With With .PivotFields("Q3_Village") .Orientation = xlPageField .Position = 1 End With With .PivotFields("Q3_Village") .Orientation = xlDataField .Position = 1 End With End With -- Rakesh kumar khowal -- ---------------------------------------------------------------------------------- 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