pivot table - %structure with subtotals

M

Mark

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
 
Top