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 [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
