View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_17_] Mark[_17_] is offline
external usenet poster
 
Posts: 95
Default pivot table - %structure with subtotals

I want create structure percent in some column of
pivottable.
I create field in pivottable: CalculatedFields.Add
with ...
.Calculation = xlPercentOfColumn
it's work fine but..
i did early subtotals (by VBA) in source data of pivot
table and structure% (in pt) is incorrect.
Unfortunately in pt:
..Function = False
..ColumnGrand = False

don't produce effect.

Any help will by appreciate

Regards
MArk